Solved: Duplicate Flag Calculation in load script - Qlik Community

Report Inappropriate Content · ‎2013-09-02

Hi,

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

Ex:

I need the script to calculate the column 2.

MayilVahanan · ‎2013-09-02

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

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.

MayilVahanan · ‎2013-09-02

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

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.

Report Inappropriate Content · ‎2013-09-02

Thanks, Its worked.