topic Re: Please help me in using applymap function. in QlikView

Please help me in using applymap function.

durgabhavani — Fri, 11 May 2018 11:53:17 GMT

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.

Re: Please help me in using applymap function.

Miguel_Angel_Baeyens — Fri, 11 May 2018 11:58:58 GMT

You have the details here:

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

MappingTable:

MAPPING LOAD

Empid,

Country

FROM ...

LOAD

Empid,

ApplyMap('MappingTable', Empid) AS New_Country

FROM ...

Re: Please help me in using applymap function.

sunny_talwar — Fri, 11 May 2018 12:03:16 GMT

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

Re: Please help me in using applymap function.

jaumecf23 — Fri, 11 May 2018 12:05:46 GMT

Hi,

Attached you can find a solution

Re: Please help me in using applymap function.

Colin-Albert — Fri, 11 May 2018 12:42:08 GMT

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.

Re: Please help me in using applymap function.

durgabhavani — Fri, 11 May 2018 12:42:40 GMT

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.

Re: Please help me in using applymap function.

Peter_Cammaert — Fri, 11 May 2018 14:39:06 GMT

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.