Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I'm new to QlikView and have a Load somewhat like this:
Test1:
LOAD Product,
Date,
Quantity,
Customer
FROM
QV_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?
Use Qualify *
QUALIFY *;
Test2:
LOAD Product,
Date,
Quantity,
Customer
Resident Test1
Order By Date;
Drop Table Test1;
Use the below code it may helps you...
Test1:
LOAD Product,
Date,
Quantity,
Customer
FROM
QV_Date_Test.txt
(txt, codepage is 1252, embedded labels, delimiter is ',', msq);
Test2:
LOAD Product,
Date,
Quantity,
Customer
Resident Test1
Order By Date;
Drop Table Test1;
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).
Use Qualify *
QUALIFY *;
Test2:
LOAD Product,
Date,
Quantity,
Customer
Resident Test1
Order By Date;
Drop Table Test1;
thanks !