topic Re: Table Mapping in QlikView

Table Mapping

Learnerr — Thu, 16 Jun 2022 10:29:46 GMT

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

Re: Table Mapping

edwin — Thu, 16 Jun 2022 17:11:51 GMT

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);