Discussion board where members can get started with Qlik Sense.
I got a script in which has a mapping table like:
Then there's something like:
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!
Go to Solution.
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...
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