Trying to get MRNs

[smanas]

Hi I have a list of IDS I'm trying to get corresponding MRNs. I need help with formula please.

ID	MRN
1	123
2	456
3	765
4	435

[ogster1974]

Create mapping table and use ApplyMap() to lookup MRN.

Mapping

MRNMap:

Load

ID,

MRN

From....

;

Result:

Load

*,

ApplyMap('MRNMap',ID,'-Unknown') as MRN

From....

;

[smanas]

Hi thanks for the suggestion I need to use an expression. 

[smanas]

Hi @ogster1974  I'm not suing the scripting can you suggest how I can achieve using dimensions and measures?

[ShawnatQlik]

Howdy! Are these values in a table in your data model?