My input schema is
Grp_ID
Act_ID
agtxid
agtin
And if I have a duplicate row then I use a sort sage to sort on all the 4 fields and set the key change column to true.
So, in my transformer I want to put the word "MULTIPLE" if I see a duplicate record in a new output column. How can I achieve this?
Handling Duplicates
Moderators: chulett, rschirm, roy