topic Duplicate Flag Calculation in load script in QlikView https://community.qlik.com/t5/QlikView/Duplicate-Flag-Calculation-in-load-script/m-p/560892#M209339 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>How do I calculate the duplicate flag value in load script?</P><P></P><P>Ex:</P><TABLE border="0" cellpadding="0" cellspacing="0" width="162"><TBODY><TR><TD height="17" width="81">Column 1</TD><TD width="81">Column 2</TD></TR><TR><TD height="17">Product1</TD><TD>No</TD></TR><TR><TD height="17">Product2</TD><TD>No</TD></TR><TR><TD height="17">Product3</TD><TD>Yes</TD></TR><TR><TD height="17">Product3</TD><TD>Yes</TD></TR></TBODY></TABLE><P></P><P>I need the script to calculate the column 2.</P></BODY></HTML> Mon, 02 Sep 2013 15:30:11 GMT 2013-09-02T15:30:11Z Duplicate Flag Calculation in load script https://community.qlik.com/t5/QlikView/Duplicate-Flag-Calculation-in-load-script/m-p/560892#M209339 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>How do I calculate the duplicate flag value in load script?</P><P></P><P>Ex:</P><TABLE border="0" cellpadding="0" cellspacing="0" width="162"><TBODY><TR><TD height="17" width="81">Column 1</TD><TD width="81">Column 2</TD></TR><TR><TD height="17">Product1</TD><TD>No</TD></TR><TR><TD height="17">Product2</TD><TD>No</TD></TR><TR><TD height="17">Product3</TD><TD>Yes</TD></TR><TR><TD height="17">Product3</TD><TD>Yes</TD></TR></TBODY></TABLE><P></P><P>I need the script to calculate the column 2.</P></BODY></HTML> Mon, 02 Sep 2013 15:30:11 GMT https://community.qlik.com/t5/QlikView/Duplicate-Flag-Calculation-in-load-script/m-p/560892#M209339 2013-09-02T15:30:11Z Re: Duplicate Flag Calculation in load script https://community.qlik.com/t5/QlikView/Duplicate-Flag-Calculation-in-load-script/m-p/560893#M209340 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>Try like this</P><P></P><P>Load If(Previous([Column 1] = [Column 1], 'Yes', 'No') As "Column 2" from tablename order by [Column 1] asc;</P><P></P><P>Hope that helps</P></BODY></HTML> Mon, 02 Sep 2013 15:31:59 GMT https://community.qlik.com/t5/QlikView/Duplicate-Flag-Calculation-in-load-script/m-p/560893#M209340 MayilVahanan 2013-09-02T15:31:59Z Re: Duplicate Flag Calculation in load script https://community.qlik.com/t5/QlikView/Duplicate-Flag-Calculation-in-load-script/m-p/560894#M209341 <HTML><HEAD></HEAD><BODY><P>Thanks, Its worked.</P></BODY></HTML> Mon, 02 Sep 2013 15:37:00 GMT https://community.qlik.com/t5/QlikView/Duplicate-Flag-Calculation-in-load-script/m-p/560894#M209341 2013-09-02T15:37:00Z