Duplicate Flag Calculation in load script

[#1]

Hi,

How do I calculate the duplicate flag value in load script?

Ex:

Column 1	Column 2
Product1	No
Product2	No
Product3	Yes
Product3	Yes

I need the script to calculate the column 2.

[MayilVahanan · Accepted solution]

Hi

Try like this

Load If(Previous([Column 1] = [Column 1], 'Yes', 'No') As "Column 2" from tablename order by [Column 1] asc;

Hope that helps

[#3]

Thanks, Its worked.