Mapping load

[New-Qlik]

Hellow,

I ahve a table wuith few columns i wnat to replace one column with data coming from other excel sheet.

I tried ampping load but didnt get accurate result.

MainTable:

Name id Code

AAA , 01

AAA , 03

AAA ,10

AAA ,11

bbb, 01

bbb, 03

bbb,10

bbb,11

code value should be replaced with code_test from different excel

ie below

AAA , 01

AAA , 03

AAA ,05

AAA ,06

bbb, 01

bbb, 03

bbb,05

bbb,06

[mahaveerbiraj]

Hi Avaneet,

could you please mention your mapping code 

Thanks & Regards 

Mahaveer 

[New-Qlik]

Maptable:

Mapping

Load 

Name,

code_new

from ***

//////////////////////////////////////////////

Maintable:

Load *,

ApplyMap('Maptable', "Name") as new_code

From ***

[abhishek2]

Try this:

ApplyMap('Maptable', Name) as new_code

[New-Qlik]

Thanks for replying, it didnt work. I want to amp based on combination of these two columns name and code

[JordyWegman]

Hi Avneet,

Isn't your field the in the main table called [Name id]? 

Then use this mapping load:

ApplyMap('Maptable', [Name id],'**') as new_code

It needs the field on which it will be mapped.

Jordy

Climber 

[New-Qlik · Accepted solution]

i did it by concatenating name and code and created new field. Finally did apply map based on this new concatenated fields and it worked.

[New-Qlik]

Hi ,

i have there columns in mapping table so i concatenate two columns.

CodeMapping:
Mapping
LOAD
Name & Code as NameCode,
Code_new
FROM **;

Load
Employee_id,
Name
NameCode,

ApplyMap('CodeMapping',"NameCode") as Code
From **

Rergards

AT