topic Re: Eliminate Duplicate Records in QlikView https://community.qlik.com/t5/QlikView/Eliminate-Duplicate-Records/m-p/493276#M184513 <HTML><HEAD></HEAD><BODY><P>Can you post asample</P></BODY></HTML> Tue, 17 Dec 2013 09:52:16 GMT sujeetsingh 2013-12-17T09:52:16Z Eliminate Duplicate Records https://community.qlik.com/t5/QlikView/Eliminate-Duplicate-Records/m-p/493275#M184512 <HTML><HEAD></HEAD><BODY><P>Hi:</P><P> LOAD A,</P><P>&nbsp;&nbsp;&nbsp;&nbsp; B,</P><P>&nbsp;&nbsp;&nbsp;&nbsp; C,</P><P>&nbsp;&nbsp;&nbsp;&nbsp; D,</P><P>&nbsp;&nbsp;&nbsp;&nbsp; E,</P><P>&nbsp;&nbsp;&nbsp;&nbsp; F,</P><P>&nbsp;&nbsp;&nbsp;&nbsp; G</P><P>FROM</P><P>C:\Users\QVCONS\Desktop\DATA.txt</P><P>(txt, codepage is 1252, embedded labels, delimiter is ',', msq) </P><P></P><P>WHERE NOT EXISTS(*);</P><P></P><P>But it is not working. </P><P></P><P>My intentions is to write all the columns. Is there any shortcut ?</P></BODY></HTML> Tue, 17 Dec 2013 09:51:06 GMT https://community.qlik.com/t5/QlikView/Eliminate-Duplicate-Records/m-p/493275#M184512 2013-12-17T09:51:06Z Re: Eliminate Duplicate Records https://community.qlik.com/t5/QlikView/Eliminate-Duplicate-Records/m-p/493276#M184513 <HTML><HEAD></HEAD><BODY><P>Can you post asample</P></BODY></HTML> Tue, 17 Dec 2013 09:52:16 GMT https://community.qlik.com/t5/QlikView/Eliminate-Duplicate-Records/m-p/493276#M184513 sujeetsingh 2013-12-17T09:52:16Z Re: Eliminate Duplicate Records https://community.qlik.com/t5/QlikView/Eliminate-Duplicate-Records/m-p/493277#M184514 <HTML><HEAD></HEAD><BODY><P>Have you tried a</P><P></P><P>LOAD DISTINCT ...</P><P></P><P>without the WHERE clause?</P></BODY></HTML> Tue, 17 Dec 2013 09:52:20 GMT https://community.qlik.com/t5/QlikView/Eliminate-Duplicate-Records/m-p/493277#M184514 swuehl 2013-12-17T09:52:20Z