Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi there
I am loading data in from spreadsheets
one of the columns being loaded in (testID), I need to retain the original order that column was in the spreadsheet.
for example
for one batch we have up to 12 rows of data
so we load all columns, but I need somehow somewhere to ensure that when i display the data in a table format, the (testID) data needs to be in the same original order as was in the spreasheet. QlikView try's to auto sort, and this is causing issues.
Any ideas on how to always retain the original order sequence.
regards
In you load script:
RowNo() as LineNo,
Then sort by LineNo