Load multiple fields from a table as a single list (dimension)

[davyqliks]

Hi All,

I had a method i thought was working but i found there to be an issue.

I have fields in a table:

Label 1,

Label 2,

Label 3 and so on up so 17.

I want to show them in a single list with all Labels.

So i load all the Labels, store the data (including other fields into a qvd) and then load like this with "Order" being the link back to the data,

ItemLoads:

Load
"Order",
"Label 1" as Items
FROM [lib://Qlik Sense E Drive/Live/Data.QVD](qvd)
;

Concatenate

Load
"Order",
"Label 2" as Items
FROM [lib://Qlik Sense E Drive/Live/Data.QVD](qvd)
;

Concatenate
Load
"Order",
"Label 3" as Items
FROM [lib://Qlik Sense E Drive/Live/Data.QVD](qvd)
;

Concatenate

.... Upto 17.

When i check the table i have items which do not belong to the filtered "Order".

I have no synthetic keys in the data model and all linked by Key fields Order.

Can anyone advise what i may be doing wrong here?

Thanks so much in advance.

kr

Daniel

[micheledenardi · Accepted solution]

Daniel,

if the data inside your QVD are consistent, you won't have problem using multiple Concatenate() statement.

Can be other Loads which can affect your datamodel?

Can you post the full script and datamodel?

[marcus_sommer]

Take a look on the additionally load-prefix of crosstable which could transform your whole table at once.

- Marcus

[davyqliks]

Thanks ,

I realised after importing the filebase name, the unique po was not unique and was in other files with different items which was causing the confusion.

Thank you for you time and advice.

Daniel