AnsweredAssumed Answered

Method to create unique values for two related attributes and make two variables

Question asked by cpoynter on May 16, 2013
Latest reply on May 19, 2013 by cpoynter
Hi All,

The situation:

1 FC / 3 related columns / definitionQuery on one field has ' as part of field name for only some records which is causing problems

Column 1 = numeric code
Coumns 2 and 3 = text (both have troublesome ' when it comes to definition query)

I want to use Column 1 value that relates to Column 3, use Column 1 value for definition query to get around ' issues, but then need value of Column 3 for layout text element.

How do I get a unique listing of the related column 1 and 3 and then seperate their values for two subsequent operations?

I am thinking da.SearchCursor but unsure how to get fields in, make unique values and seperate values.

Thankyou in advance.

Using ArcGIS 10.1

Regards,

Craig

Outcomes