topic Re: urgent request in QlikView https://community.qlik.com/t5/QlikView/urgent-request/m-p/705997#M1069909 <HTML><HEAD></HEAD><BODY><P>Hi</P><P>You can use incremental load to avoid duplication in records if your database update on daily basis...</P><P>otherwise use distinct as mentioned in above reply.</P></BODY></HTML> Thu, 04 Sep 2014 09:16:03 GMT noman212 2014-09-04T09:16:03Z urgent request https://community.qlik.com/t5/QlikView/urgent-request/m-p/705993#M1069905 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>As I have a qvd that has the same record twice like if the orginal recrod like 100 means it has 200 how to remove the duplicate records</P><P>pls advice</P></BODY></HTML> Thu, 04 Sep 2014 07:07:11 GMT https://community.qlik.com/t5/QlikView/urgent-request/m-p/705993#M1069905 2014-09-04T07:07:11Z Re: urgent request https://community.qlik.com/t5/QlikView/urgent-request/m-p/705994#M1069906 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>Use Distinct() method to load originals only without duplicates in the script.</P><P>for ex:</P><P></P><P>Load Distinct(id)</P><P>from table;</P><P></P><P>This may help you.</P><P></P><P>-Charitha.</P></BODY></HTML> Thu, 04 Sep 2014 07:08:49 GMT https://community.qlik.com/t5/QlikView/urgent-request/m-p/705994#M1069906 2014-09-04T07:08:49Z Re: urgent request https://community.qlik.com/t5/QlikView/urgent-request/m-p/705995#M1069907 <HTML><HEAD></HEAD><BODY><P>Load <STRONG>Distinct </STRONG></P></BODY></HTML> Thu, 04 Sep 2014 07:09:24 GMT https://community.qlik.com/t5/QlikView/urgent-request/m-p/705995#M1069907 tresB 2014-09-04T07:09:24Z Re: urgent request https://community.qlik.com/t5/QlikView/urgent-request/m-p/705996#M1069908 <HTML><HEAD></HEAD><BODY><P>Dear Chriss,</P><P></P><P>Kindly, find attached document.</P><P></P><P></P><P>Kind regareds,</P><P>Ishfaque Ahmed</P></BODY></HTML> Thu, 04 Sep 2014 07:27:13 GMT https://community.qlik.com/t5/QlikView/urgent-request/m-p/705996#M1069908 engishfaque 2014-09-04T07:27:13Z Re: urgent request https://community.qlik.com/t5/QlikView/urgent-request/m-p/705997#M1069909 <HTML><HEAD></HEAD><BODY><P>Hi</P><P>You can use incremental load to avoid duplication in records if your database update on daily basis...</P><P>otherwise use distinct as mentioned in above reply.</P></BODY></HTML> Thu, 04 Sep 2014 09:16:03 GMT https://community.qlik.com/t5/QlikView/urgent-request/m-p/705997#M1069909 noman212 2014-09-04T09:16:03Z