Pick up last occurrence of duplicate record

Situation:

I want to filter duplicate records on the basis of "SSN/First name/Last name", but I want the duplicate record going to the target to be the last occurrence of that combination in the source file.

Ex:

Input

Emp_SSN, Emp_FName, Emp_LName, Role

123456789, Carl, Weathers, Apollo

123456789, Carl, Weathers, Dillon

Output

123456789, Carl, Weathers, Dillon

Tip:

Use the below "For Each" condition at the Record level and it will transfer the last occurrence of the duplicate record to the target

$Input_Source_Schema/Root/Record[not(normalize-space(following::Emp_SSN) = normalize-space(Emp_SSN))and not(normalize-space(following::Emp_FName)=normalize-space(Emp_FName)) and not(normalize-space(following::Emp_LName)=normalize-space(Emp_LName))]

Have more questions? Submit a request

0 Comments

Article is closed for comments.