Discussion board where members can get started with QlikView.
I'm new to QlikView and have a Load somewhat like this:
Test1:LOAD Product, Date, Quantity, CustomerFROMQV_Date_Test.txt(txt, codepage is 1252, embedded labels, delimiter is ',', msq);
I want to Order by Date, and find in the Reference Manual that I have to use a resident table.Based on my Load, what will be the next to write in the script to get this right?
Go to Solution.
Use Qualify *
Order By Date;
Drop Table Test1;
Use the below code it may helps you...
(txt, codepage is 1252, embedded labels, delimiter is ',', msq);
If I drop Table Test1, no data exists - Table Test2 is not there, (if I don't Drop Table Test1, I only have one Table (Test1), but then the number of records have been doubled).