need help on the below code

[andrea0901]

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.

[Sue_Macaluso]

@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

[andrea0901]

to New Qlik Community

[Sue_Macaluso]

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