Hi,

Regarding - Chapter6-Solution.dtsx package, which process duplicate rows from table inCustomers.

I have one question:
I did not see how the derived column "rowScore" is used after it is populated.

does this make sense to anyone outthere?
Thank you.

Regards,
Minnie

Hi,

I realized that I understand the logic now after I 'walk through' the code against the row-set 'row by row'. The key thing I was missing is that the rows were sorted within the duplicate group already, hence the script only mark the 1st row within the group.

Regards,
Minnie