Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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