topic How to remove duplicate rows frm data sources. in QlikView https://community.qlik.com/t5/QlikView/How-to-remove-duplicate-rows-frm-data-sources/m-p/206398#M1207022 <HTML><HEAD></HEAD><BODY><P>I want to remove duplication in my data sorce.How to do?</P></BODY></HTML> Fri, 11 Dec 2009 15:00:41 GMT 2009-12-11T15:00:41Z How to remove duplicate rows frm data sources. https://community.qlik.com/t5/QlikView/How-to-remove-duplicate-rows-frm-data-sources/m-p/206398#M1207022 <HTML><HEAD></HEAD><BODY><P>I want to remove duplication in my data sorce.How to do?</P></BODY></HTML> Fri, 11 Dec 2009 15:00:41 GMT https://community.qlik.com/t5/QlikView/How-to-remove-duplicate-rows-frm-data-sources/m-p/206398#M1207022 2009-12-11T15:00:41Z How to remove duplicate rows frm data sources. https://community.qlik.com/t5/QlikView/How-to-remove-duplicate-rows-frm-data-sources/m-p/206399#M1207023 <HTML><HEAD></HEAD><BODY><P>Use the DISTINCT keyword in the LOAD. For example</P><P>LOAD DISTINCT Customer, OrderID, Date etc</P><P>-Rob</P></BODY></HTML> Sat, 12 Dec 2009 02:11:23 GMT https://community.qlik.com/t5/QlikView/How-to-remove-duplicate-rows-frm-data-sources/m-p/206399#M1207023 rwunderlich 2009-12-12T02:11:23Z How to remove duplicate rows frm data sources. https://community.qlik.com/t5/QlikView/How-to-remove-duplicate-rows-frm-data-sources/m-p/206400#M1207024 <HTML><HEAD></HEAD><BODY><P>Ya.This waht I want.Thnks.</P><P></P><P>Then I have another scenario such as I need to update new values for already existing rows and also want to add new rows to the same table. at the same time...How to do?</P></BODY></HTML> Mon, 14 Dec 2009 12:31:03 GMT https://community.qlik.com/t5/QlikView/How-to-remove-duplicate-rows-frm-data-sources/m-p/206400#M1207024 2009-12-14T12:31:03Z How to remove duplicate rows frm data sources. https://community.qlik.com/t5/QlikView/How-to-remove-duplicate-rows-frm-data-sources/m-p/206401#M1207027 <HTML><HEAD></HEAD><BODY><P>If I understand correctly, it sounds like you want to do an Incremental Load. Check out Incremental Load in the Ref Guide. You can also find a complete Incremental Load example in the QV Cookbook.</P><P>-Rob</P></BODY></HTML> Mon, 14 Dec 2009 15:07:49 GMT https://community.qlik.com/t5/QlikView/How-to-remove-duplicate-rows-frm-data-sources/m-p/206401#M1207027 rwunderlich 2009-12-14T15:07:49Z