topic Re: How to handle Duplicate records in Qlikview ?? in QlikView https://community.qlik.com/t5/QlikView/How-to-handle-Duplicate-records-in-Qlikview/m-p/678762#M1060012 <HTML><HEAD></HEAD><BODY><P>Hi, </P><P></P><P>LOAD Distinct ....</P><P>I suppose.</P><P></P><P>Hope this helps.</P><P></P><P>Andrei</P></BODY></HTML> Wed, 24 Sep 2014 09:01:18 GMT crusader_ 2014-09-24T09:01:18Z How to handle Duplicate records in Qlikview ?? https://community.qlik.com/t5/QlikView/How-to-handle-Duplicate-records-in-Qlikview/m-p/678761#M1060010 <HTML><HEAD></HEAD><BODY><P>Hey,</P><OL style="list-style-type: decimal;"><LI><SPAN style="font-size: 14.0pt; font-family: 'Cambria','serif';">How to handle Duplicate records in Qlikview ??</SPAN></LI></OL><P><SPAN style="font-size: 14.0pt; font-family: 'Cambria','serif';">Thanks</SPAN></P></BODY></HTML> Wed, 24 Sep 2014 08:52:56 GMT https://community.qlik.com/t5/QlikView/How-to-handle-Duplicate-records-in-Qlikview/m-p/678761#M1060010 nikhilgarg 2014-09-24T08:52:56Z Re: How to handle Duplicate records in Qlikview ?? https://community.qlik.com/t5/QlikView/How-to-handle-Duplicate-records-in-Qlikview/m-p/678762#M1060012 <HTML><HEAD></HEAD><BODY><P>Hi, </P><P></P><P>LOAD Distinct ....</P><P>I suppose.</P><P></P><P>Hope this helps.</P><P></P><P>Andrei</P></BODY></HTML> Wed, 24 Sep 2014 09:01:18 GMT https://community.qlik.com/t5/QlikView/How-to-handle-Duplicate-records-in-Qlikview/m-p/678762#M1060012 crusader_ 2014-09-24T09:01:18Z Re: How to handle Duplicate records in Qlikview ?? https://community.qlik.com/t5/QlikView/How-to-handle-Duplicate-records-in-Qlikview/m-p/678763#M1060013 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>You can use Rowno() function to make the duplicate records unique in case that's what you are looking for.</P><P></P><P>Example</P><P></P><P>Load *, RecNo( ), RowNo( ) from tablename;</P><P></P><P>thanks,</P><P>Rajesh Vaswani</P></BODY></HTML> Wed, 24 Sep 2014 09:01:46 GMT https://community.qlik.com/t5/QlikView/How-to-handle-Duplicate-records-in-Qlikview/m-p/678763#M1060013 rajeshvaswani77 2014-09-24T09:01:46Z Re: How to handle Duplicate records in Qlikview ?? https://community.qlik.com/t5/QlikView/How-to-handle-Duplicate-records-in-Qlikview/m-p/678764#M1060015 <HTML><HEAD></HEAD><BODY><P>Interview question?</P><P></P><P>Distinct would be the obvious. You have to be careful when joining tables which don't have a distinct key as they will cause duplicate rows in the original table.</P><P></P><P>Trick is to keep checking your data after everything you change in the script.</P><P></P><P>Rcihard</P><P>QlikCentral.com</P></BODY></HTML> Wed, 24 Sep 2014 09:04:33 GMT https://community.qlik.com/t5/QlikView/How-to-handle-Duplicate-records-in-Qlikview/m-p/678764#M1060015 richard_pearce6 2014-09-24T09:04:33Z Re: How to handle Duplicate records in Qlikview ?? https://community.qlik.com/t5/QlikView/How-to-handle-Duplicate-records-in-Qlikview/m-p/678765#M1060016 <HTML><HEAD></HEAD><BODY><P>HEy,</P><P>Cann't i use Distinct keyword ?? And what is this RecNo( ), RowNo( ) used for ??</P><P>What does this RecNo( ), RowNo( ) returns ??</P><P></P><P>Thanks</P></BODY></HTML> Wed, 24 Sep 2014 09:09:36 GMT https://community.qlik.com/t5/QlikView/How-to-handle-Duplicate-records-in-Qlikview/m-p/678765#M1060016 nikhilgarg 2014-09-24T09:09:36Z Re: How to handle Duplicate records in Qlikview ?? https://community.qlik.com/t5/QlikView/How-to-handle-Duplicate-records-in-Qlikview/m-p/678766#M1060018 <HTML><HEAD></HEAD><BODY><P>Check this document</P><P></P><P><A _jive_internal="true" href="https://community.qlik.com/blogs/qlikviewdesignblog/2014/08/29/recno-or-rowno" title="http://community.qlik.com/blogs/qlikviewdesignblog/2014/08/29/recno-or-rowno">http://community.qlik.com/blogs/qlikviewdesignblog/2014/08/29/recno-or-rowno</A></P><P></P><P>Hope this helps.</P><P></P><P>Andrei</P></BODY></HTML> Wed, 24 Sep 2014 09:13:30 GMT https://community.qlik.com/t5/QlikView/How-to-handle-Duplicate-records-in-Qlikview/m-p/678766#M1060018 crusader_ 2014-09-24T09:13:30Z Re: How to handle Duplicate records in Qlikview ?? https://community.qlik.com/t5/QlikView/How-to-handle-Duplicate-records-in-Qlikview/m-p/678767#M1060020 <HTML><HEAD></HEAD><BODY><P>Use Distinct(Field) during load </P></BODY></HTML> Wed, 24 Sep 2014 09:14:16 GMT https://community.qlik.com/t5/QlikView/How-to-handle-Duplicate-records-in-Qlikview/m-p/678767#M1060020 ychaitanya 2014-09-24T09:14:16Z Re: How to handle Duplicate records in Qlikview ?? https://community.qlik.com/t5/QlikView/How-to-handle-Duplicate-records-in-Qlikview/m-p/678768#M1060021 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>If you want to remove duplicate then use Duplicate keyword like below</P><P></P><P>LOAD DISTINCT</P><P>*</P><P>FROM Table1;</P><P></P><P>Data:</P><P>LOAD DISTINCT</P><P>A</P><P>FROM Table1</P><P>WHERE NOT EXISTS(<SPAN class="Code">A);</SPAN> </P><P></P><P>Regards,</P><P>Jagan.</P></BODY></HTML> Wed, 24 Sep 2014 09:27:40 GMT https://community.qlik.com/t5/QlikView/How-to-handle-Duplicate-records-in-Qlikview/m-p/678768#M1060021 jagan 2014-09-24T09:27:40Z Re: How to handle Duplicate records in Qlikview ?? https://community.qlik.com/t5/QlikView/How-to-handle-Duplicate-records-in-Qlikview/m-p/678769#M1060023 <HTML><HEAD></HEAD><BODY><P>HEy,</P><P>How does RecNo() and RowNo() helps in handling dupliacte records ??</P></BODY></HTML> Thu, 25 Sep 2014 05:39:42 GMT https://community.qlik.com/t5/QlikView/How-to-handle-Duplicate-records-in-Qlikview/m-p/678769#M1060023 nikhilgarg 2014-09-25T05:39:42Z