Alphabetical load order

[Anonymous]

I'm loading data into a table, I've concatenated it to show you simply. The data is loaded in this order:

Janes Crisps

Bobs burgers

Dave’s tyres

However, when i load it in qlikview it comes through like this:

Bobs burgers

Dave’s tyres

Janes Crisps

It runs them through alphabetically. I've changed the sort type to 'load order' but that doesnt work. Can anyone tell me how i load information so that it isnt alphabetical and that it loads it as it's stored in the table?

[Anonymous]

This is what i have so far - still uploading alphabetically

any suggestions?

[whiteline · Accepted solution]

Doesn't it what you want ?

subfield(concat([Company name],',', [Row]),',',1) = Janes Crisps

subfield(concat([Company name],',', [Row]),',',2) = Bobs burgers

subfield(concat([Company name],',', [Row]),',',3) = Dave’s tyres