need help on the below code

andrea0901 — Wed, 25 Nov 2020 16:16:04 GMT

Hi All,

My Final table has:

Final_Table

Load *,
EKPO.LIFNR&RBKP.Source as Key2
Resident tmp;
Drop table tmp;

I created a table in excel as below:

Excel file: I mapped the sourcesystem to RBKP.source

SOURCESYSTEM	RBKP.Source
C0_	CEP
C1_	SPC
H4_	MPD
H3_	PR1
H1_	MBP
H5_	HHS
S4_	PIL
H2_	MCP
H4_	MPD

Below is my mapping table:

SourceSystem:
Mapping
LOAD [Source System],
Source
FROM
the above excel file

Now I have 2 Qvd’s and the fields are below:

First QVD:

Left join(Final_Table)

LOAD
     SOURCESYSTEM,
     Applymap('SourceSystem',SOURCESYSTEM,'na') as RBKP.Source,
     VENDORNUMBER,
     VGUID,
     VENDORNUMBER&SOURCESYSTEM as Key2

FROM
firstQVD;

I did applymap and created a key2 in my final table and in first QVD.

Second QVD:

Left join(Final_Table)

Load VGUID,

VGUNAME

From secondQVD;

But the problem here is I am not getting VGUID and VGUNAME from second table.

My output for VendorNumber, VGUID and VGUname is blank.

Please help me.

Re: need help on the below code

Sue_Macaluso — Tue, 29 Jan 2019 13:33:41 GMT

@andrea0901. Which product are you referring to in this post. I would like to move this to the correct product forum. This forum is for general non product discussions. Thanks

Re: need help on the below code

andrea0901 — Tue, 29 Jan 2019 13:36:24 GMT

to New Qlik Community

Re: need help on the below code

Sue_Macaluso — Tue, 29 Jan 2019 18:04:41 GMT

Is this for the QlikView product or Qlik Sense Product? Thank you

topic Re: need help on the below code in QlikView

need help on the below code

Re: need help on the below code

Re: need help on the below code

Re: need help on the below code