Handling Duplicates

ppp · Post by **ppp** » Thu Mar 11, 2010 12:36 pm

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?

dsedi · Post by **dsedi** » Thu Mar 11, 2010 1:57 pm

Use the BASIC transformer and the RowProcCompareWithPreviousValue Transform funtion will accomplish the requirement.

chulett · Post by **chulett** » Thu Mar 11, 2010 2:15 pm

Do it based on the value of the key change column. Once you run some data through and see what it looks like, the 'how' will be obvious.