+3I 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?
Best answer by jlbaker2779
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.
+2Matcher 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.
+46If 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"
+3Thanks. I didn't see a "group by" option but went ahead with the SingleMatched port and got the expected 1,608 records. THANKS!
