how to Link a generic load to main data table

[Daniel77]

Hi,

I have used a generic load for the first time to create columns from rows in the load:

Scores:
Generic
Load
"Production Facility T1",
subfield([Audit Date],'-',1) as AuditYear,
"Score letter" as ScoreHistory

Resident
FINALLOAD
;

This works as hoped in a table on its own as below:

however, when i try to add these fields, 2020.2021..... to a table with more dimensions i find the data is no linked and the scores are duplicated per row.

I have tried to join and concatenate the table to the main load to link the fields in but with no success.

When i try to add another field to the generic load i am finding the correct fields created, 2020,2021,2022 are now missing.

Can anyone gibe any information on how i can link a generic load into my main data table to the fields created are linked?

thank you 

Daniel

[marcus_sommer]

Take a look on this: The Generic Load - Qlik Community - 1473470

[Daniel77]

Thank you,

I will take a look at this, if i have any question i may come back if thats ok.

Thank you Marcus.

Daniel