Mapping

[wanyunyang]

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!

[MK_QSL]

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

[maxsheva · Accepted solution]

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/Mapp...