Skip to main content
Solved

Manual join for unmatched data.

  • April 12, 2024
  • 1 reply
  • 35 views

cosminciotina
Contributor
Forum|alt.badge.img+3

Hi there,

I have a small project where I've performed a join between two tables (Table1 and Table2) using the CityName field as a common identifier.

However, I've noticed some minor inconsistencies in the city names between the two tables, resulting in 10 unjoined features.

Is there a transformer or method available to manually specify that the X row from Table1 should be joined with the Y row from Table2?

Regards

 

 

 

Best answer by nielsgerrits

I would just fix the mismatches in CityName, using a StringReplacer, upstream of the Featuremerger / FeatureJoiner.

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

1 reply

nielsgerrits
VIP
Forum|alt.badge.img+54
  • Best Answer
  • April 12, 2024

I would just fix the mismatches in CityName, using a StringReplacer, upstream of the Featuremerger / FeatureJoiner.


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