Please help me in using applymap function.

[durgabhavani]

Hi All,

I am looking to map the values to empid in existing table using mapping file using applymap function .

My existing table

Empid
101
102
103
104
105
106
107
108
109
110

Mapping file:

Empid	Country
101	us
102	India
103	Srilanka
104	pak
105	aus
106	uk
107	uk

Expected Output:

Empid	New_Country
101	us
102	India
103	Srilanka
104	pak
105	aus
106	uk
107	uk

Please advice.

[Miguel_Angel_Baeyens · Accepted solution]

You have the details here:

https://help.qlik.com/en-US/qlikview/November2017/Subsystems/Client/Content/Scripting/MappingFunctio...

MappingTable:

MAPPING LOAD

  Empid,

  Country

FROM ...

LOAD

  Empid,

  ApplyMap('MappingTable', Empid) AS New_Country

FROM ...

[sunny_talwar]

Seems like a simple ApplyMap, what is the issue that you are running into?

[jaumecf23]

Hi,

Attached you can find a solution

[Colin-Albert]

Mapping tables are clearly explained in this blog by hic‌  Don't join - use Applymap instead

Jus remember you need to load the mapping data using the "mapping load" command before using the applymap command.

[durgabhavani]

Miguel,

yes. I am able to get the output.

Sunny,

I found the issue. I have no matched customer numbers in my data so not able to get the expected output.

Now I have added the matched records in my mapping file and able to get the expected output.

Thanks all.

Marking the question as answered. Qlikcommunity responded slowly, submit the same request again.

[Peter_Cammaert]

In some countries, today may be a Bank Holiday. You shouldn't assume any response time limit for getting answers. In a slow day, it can take a while for your question to get picked up. This community is a volunteer effort after all.

If you're really in a hurry, better bump your original post back to the top of the recent submissions list by adding a simple post like "Anyone?".

Please close your other post Please help me in using applymap function. by marking it as "Assumed Answered" or by simply deleting it. Otherwise, people that don't know that your question has been answered will still spend time and energy on an old case.

Thanks.