Is there a Qlik applymap('mapid', FIELD, "no match") equiv?

I am not good with SQL, so I love the applymap() function which allows you to use a Foreign Key to lookup a value in another table.
Does EasyMorph have something similar?
I couldn't find anything - what's the best way to do this?


User Table
username: jp

Employee Table:
username: jp
fullname: john-paul dellaputta

applymap allows us to use the 'jp' value to return 'john-paul dellaputta' and add that as a new field or column.

Hi John-Paul,

In EasyMorph, use the "Lookup" action for that.

1 Like

I was searching for everything but Lookup.
Makes sense.