2 Replies Latest reply: Mar 28, 2018 11:22 AM by Max Shevchenko

Mapping

Wanyun Yang Mar 28, 2018 11:06 AM

Hi guys,

I got a script in which has a mapping table like:

User:

mapping load

userId,

companyCode

resident T1;

Then there's something like:

Applymap('User',rewardUser,' ')

I don't really get this. Does it mean User mapping table maps userId to companyCode? If so, what is rewardUser in ApplyMap?

Thanks in advance!

Re: Mapping

Manish Kachhia Mar 28, 2018 11:17 AM (in response to Wanyun Yang)

rewardUser is the field in the table where ApplyMap is used.
This applymap will give you companyCode from User Mapping Load table.
You can read further how it works from here.

Don't join - use Applymap instead
Like Show 0 Likes (0)

Actions
Re: Mapping

Max Shevchenko Mar 28, 2018 11:22 AM (in response to Wanyun Yang)

Hi,
I suppose Applymap() is somewhere in other table.
It loads rewardUser from source.

Applymap function is looking for values from rewardUser in userId field.
If equals then take companyCode value.

Please check for details https://help.qlik.com/en-US/sense/September2017/Subsystems/Hub/Content/Scripting/ScriptPrefixes/Mapping.htm
Like Show 0 Likes (0)

Actions