Load order

[Anonymous]

Hi guys. I’ve got the following table

Client Manager	Company name	Client name	Phone number
Sarah	Bobs burgers	Sarah Smith	01233444444
Sarah	Bobs burgers	Ed Jones	01234656565
Sarah	Dave’s tyres	Dan Jackson	01233555566
Robert	Steve’s fish-shop	Jacob Green	01222333555

I load this from a file:

Load

[Client Manager],

[Company Name],

[Client name],

[Phone number]

FROM

(ooxml, embedded labels, table is Sheet1);

I’ve created a table which looks like this to sort them into client manager:

Client Manager	Company 1	Client 1	Company 2	Client 2	Company 3	Client 3
Sarah	Bobs burgers	Sarah Smith	Bobs burgers	Ed Jones	Dave’s tyres	Dan Jackson
Robert	Steve’s fish-shop	Jacob Green

Using the following:

subfield(concat([Company Name],','),',',1)

subfield(concat([Client Name],','),',',1)

However, these get mixed up (as the company names load in alphabetical order) which loads them like this

Client Manager	Company 1	Client name	Company 2	Client name	Company 3	Client name
Sarah	Bobs burgers	Dan Jackson	Bobs burgers	Ed Jones	Dave’s tyres	Sarah Smith
Robert	Steve’s fish-shop	Jacob Green

Is there any way to load the original order (like you would do with an inline) but from an actual file?

See attached files for more information

[#2]

Hello,

Are you changing your index of your subfield accordingly

subfield(concat([Company Name],','),',',1) for Company 1

subfield(concat([Company Name],','),',',2) for company 2

Thanks,

[sujeetsingh]

Why dont you ceck for load order sorting.

[Gysbert_Wassenaar · Accepted solution]

See attached qvw

[Anonymous]

Looks like Gysbert Wassenaar has it - one question though, where on earth does vCompanyConcat come from?

[Gysbert_Wassenaar]

It's a variable I added to make the expressions simpler. Same for the variable vClientConcat. In other words, I moved part of the expression to a variable and use the variable in the expression instead. Make reuse possible and so reduces typing, maintenance and chance of errors because of typo's.

[Anonymous]

The information isn't coming through as loaded, it's still coming through alphabetically - how can i get it to come through as loaded so that

Client Manager	Company name	Client name	Phone number
Sarah	Toms trucks	Joe	01233444444
Sarah	Bobs burgers	Ed Jones	01234656565
Sarah	Dave’s tyres	Dan Jackson	01233555566
Robert	Steve’s fish-shop	Jacob Green	01222333555

comes through correctly. As it stands it comes through as

Bobs burgers - Dan Jackson

Dave's tyres - Ed Jones

Toms Trucks - Joe