AnsweredAssumed Answered

How to script? From a single column: Fill 2nd table with unique values, then count total of each...

Question asked by dmeriwether on Apr 7, 2011
Latest reply on Apr 8, 2011 by philmodjunk

Title

How to script? From a single column: Fill 2nd table with unique values, then count total of each value in second field

Post

I have Table A - 25,000+ names. It contains a field "County" for county residence. I want to fill an empty, Table B with the list of uniques in one field, then a Count of total occurrences for each county. Table B:CountyID as key.

Ideally, a rerun of the script when name data updates are sent would generate a new list of counties and a new count.

I do some FM scripting - enough to be dangerous. But this is over my head. Any help? Any examples or snippets so I can see clean code? Thanks in advance.

Outcomes