vlookup in Qlik Sense

[RubenMoreno]

Hello,

I have a question where you might be able to support.

I loaded two tables in QlikSense

[TableA] containing columns Column1/Column2/.../Key

[TableB] containing columns ColumnZ/ColumnY/.../Key/Team

I want to create an extra column in [TableA] called Team  where the value is the one linked to Key in [TableB]. Basically I want to perform a typical vlookup in Excel.

I tried with ApplyMap function but somehow is not working. Can you help?

Thank you.

Best regards,
Rubén

[Anil_Babu_Samineni · Accepted solution]

Perhaps this?

TableB:
Mapping Load Key, Team From TableB;

TableA:
Load Key, ApplyMap('TableB', Team) as Team From TableA;

[RubenMoreno]

Hello @Anil_Babu_Samineni ,

I keep having one issue and it is that after "FROM", it does not recognize TableA or TableB as a table. Purple color is missing as you see in the screenshot.

Do you know why?

Thanks.

Best regards,
Rubén

[Anil_Babu_Samineni]

You should use your source, [Lib://ConnectionName/....]