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