Load script- order by

[mattbrain]

Morning

I have to produce a wallboard in Crystal Report, and it will be far easier for me to prepare the source information in QlikView.

Have a simple table, that lists sales order code, and a carriage charge.

Some of the sales order codes are text, but Crystal is importing the field as numeric.

Am using QlikView so create a CSV, that Crystal can them automatically import.

The field IS_DROPSHIP is Y or N, and I an trying to sort the outputted CSV so the Y is always listed first, which I can do below, but I can't figure out a way to then STORE the CSV file.

Hope that makes sense.

Any help would be appreciated thanks.

Temp1:

LOAD IS_DROPSHIP,

     SORDER_CODE,

     TOTALCHARGE

FROM [---file.qvd](qvd)

;

Temp2:

Load  *

Resident Temp1 Order By IS_DROPSHIP asc;

store Temp1 into "---file.csv"(txt);

This script works, but the Order By is ignored