Origianl load order from excel file

spikenaylor1 — Sat, 16 Nov 2024 01:05:38 GMT

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

Re: Origianl load order from excel file

m_woolf — Tue, 10 Mar 2020 11:53:27 GMT

In you load script:

RowNo() as LineNo,

Then sort by LineNo

topic Re: Origianl load order from excel file in QlikView

Origianl load order from excel file

Re: Origianl load order from excel file