remove lines

[#1]

Hi,

I'm loading data from an oracle db table, but sometimes lines are duplicated.

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,

thanks,

David

[Miguel_Angel_Baeyens]

Hello David,

Take any unique value, then use the following

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;

Hope that helps