Skip to main content

I have many CSV tables (35) that share a common "GEO_ID" but have different attributes otherwise. There are about 1,600 records in each and every table.

 

I want to join them together by GEO_ID with a resulting output XLS file of 1,600 records and 100+ fields. I've tried FeatureJoiner with a Left Join to a "geography.csv", but always end up with 53,000+ records.

 

Also tried FeatureMerger with similar results.

 

What am I missing?

Matcher with a group by of GEO_ID is a good bet. They should come out of the SingleMatched port as 1600 records with all possible attributes appended.


If GEO_ID is the only field name they have in common you could also use an aggregator, Group on GEO_ID, ensure you choose the accumulation Mode "Merge Incoming Attributes"


Thanks. I didn't see a "group by" option but went ahead with the SingleMatched port and got the expected 1,608 records. THANKS!


Reply