Skip to main content
Solved

Manual join for unmatched data.

  • April 12, 2024
  • 1 reply
  • 44 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.

This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.

1 reply

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

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