Table Mapping

[Learnerr]

Hi experts,

We have couple of tables in a qlik reports. Some data comes from excel,some comes from SAP. I would like to add a field of SAP into the Excel table. But i dont know how to do that wihin the code.

How can i match fields? (Adding ORGEH_Tanim into the EGITIM Table)

Kind Regards

[edwin · Accepted solution]

in your load command for the Excel file, you can always add an additional field.  as long as you have the logic to generate the new field based on the fields you are puling in.

LOAD
COLUMN1,
COLUMN2,
if(COLUMN1 = ...) as ORGEH_Tanim
FROM [YOURXLS]
(ooxml, embedded labels, table is Sheet1);