Skip to main content
Solved

Join multiple CSV tables using common field


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?

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.

View original
Did this help you find an answer to your question?

3 replies

Forum|alt.badge.img+2
  • Best Answer
  • January 8, 2021

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.


ebygomm
Influencer
Forum|alt.badge.img+32
  • Influencer
  • January 8, 2021

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"


  • Author
  • January 8, 2021

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


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings