This seems easy but I'm not sure how to go about it. I want to do an initial match on ID1 and then detect if ID2 has different values. So A has different values in ID2, and B does not.
Initial data
Required Data
Solved
How can I assign a value to a new field that matches in one field but then differ in the second field?
+3- Contributor
Best answer by dustin
Feed your features into an Aggregator, with Group By processing set to both ID1 and ID2. Send the resulting features to a Matcher with Group By set to ID1, which will give you the group of features where both ID1 and ID2 always match. This will be the Supplier in a FeatureMerger, with the original features being the Requestor, merging on ID1. From the Merged port assign the DIFFERS attribute as N, and from the UnmergedRequestor assign those DIFFERS as Y.
+30- Influencer
- Best Answer
Feed your features into an Aggregator, with Group By processing set to both ID1 and ID2. Send the resulting features to a Matcher with Group By set to ID1, which will give you the group of features where both ID1 and ID2 always match. This will be the Supplier in a FeatureMerger, with the original features being the Requestor, merging on ID1. From the Merged port assign the DIFFERS attribute as N, and from the UnmergedRequestor assign those DIFFERS as Y.
+3- Contributor
dustin wrote:
Feed your features into an Aggregator, with Group By processing set to both ID1 and ID2. Send the resulting features to a Matcher with Group By set to ID1, which will give you the group of features where both ID1 and ID2 always match. This will be the Supplier in a FeatureMerger, with the original features being the Requestor, merging on ID1. From the Merged port assign the DIFFERS attribute as N, and from the UnmergedRequestor assign those DIFFERS as Y.
Works brilliantly, thank you!
It is very easy to assign the same value to another new value even if it is different. Just select the column assign the same value to both and implement it.
Reply
Rich Text Editor, editor1
Editor toolbars
Press ALT 0 for help
Helpful Members This Week
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.