simple Order by question

[#1]

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?

[jagannalla]

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;

[#3]

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).

[jagannalla · Accepted solution]

Use Qualify *

QUALIFY *;

Test2:

LOAD Product,

Date,

Quantity,

Customer

Resident Test1

Order By Date;

Drop Table Test1;

[#5]

thanks !