remibrisson

Labelling using python - Accessing other tables

Discussion created by remibrisson on May 2, 2014
Latest reply on May 8, 2014 by thanos_cp78
Hi all, I have a labelling quiz for you.

I have a point FC that identifies islands. Each point has a code to identify the island uniquely. There are no duplicates.

I also have a table (excel at this point) that stores info on bird colonies inventories (island where it is located (code)20, date inventoried, other info...).

The codes for the islands in the point FC and table are the same. There is a one to many relationship between the FC and the table.

I need to label each island with all the years that a colony was inventoried on it.  Some will have one year displayed, others two, others several...

1978

1978
1986

1986

1999

1978
1986
1999
2009

etc.

I tried joining the tables but I only get the first year that's found in the table for each point. Now I'm thinking: can I use a python script in the labelling expression that will access my table and parse it to create my labels and return them?

I bet I'm missing something simple here...

Thanks for your time

Remi

Outcomes