topic remove lines in QlikView https://community.qlik.com/t5/QlikView/remove-lines/m-p/241545#M91959 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>I'm loading data from an oracle db table, but sometimes lines are duplicated.</P><P>Is there anyway in qlikview script to avoid loading the duplicated lines? I know how to do it in sql but it takes too much time to load the data,</P><P>thanks,</P><P>David</P></BODY></HTML> Tue, 08 Mar 2011 10:03:27 GMT 2011-03-08T10:03:27Z remove lines https://community.qlik.com/t5/QlikView/remove-lines/m-p/241545#M91959 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>I'm loading data from an oracle db table, but sometimes lines are duplicated.</P><P>Is there anyway in qlikview script to avoid loading the duplicated lines? I know how to do it in sql but it takes too much time to load the data,</P><P>thanks,</P><P>David</P></BODY></HTML> Tue, 08 Mar 2011 10:03:27 GMT https://community.qlik.com/t5/QlikView/remove-lines/m-p/241545#M91959 2011-03-08T10:03:27Z remove lines https://community.qlik.com/t5/QlikView/remove-lines/m-p/241546#M91960 <HTML><HEAD></HEAD><BODY><P>Hello David,</P><P>Take any unique value, then use the following</P><P></P><BLOCKQUOTE style="overflow-x: scroll;"><PRE style="margin: 0px;">Customer:LOAD CustID, // Unique field CustNameWHERE NOT EXISTS(CustID);SQL SELECT CustID, CustNameFROM Database.Table; // The following should work as wellCustomer:LOAD DISTINCT CustID, CustName;SQL SELECT * FROM Database.Table;</PRE></BLOCKQUOTE><BR /><BR /> <P>Hope that helps</P></BODY></HTML> Tue, 08 Mar 2011 10:56:16 GMT https://community.qlik.com/t5/QlikView/remove-lines/m-p/241546#M91960 Miguel_Angel_Baeyens 2011-03-08T10:56:16Z