Match Text to a Value

[kavieweg]

I have a table with values and in the load script i have a list with the Translation of the value

Order	Value 1
A	1
B	5
C	7
D	9
E	0
F	9
G	1

   Translation

0	off
1	Speed
5	Break
7	Fast
9	Start

Now I want the text in the Value 1 column

Order	Value 1
A	Speed
B	Break
C	Fast
D	Start
E	off
F	Start
G	Speed

How can I reach this?

[kavieweg]

Oh, I think ist to Long. I am trying to find the mistake 🙂

But how does ApplyMatch know that I want F2 instead of ID?

[sunny_talwar]

It would be easy if you go back and read the basics here because it is something how applymap work... how does it work that way... I am not sure ... may be someone from Qlik can respond to that

https://help.qlik.com/en-US/qlikview/November2017/Subsystems/Client/Content/Scripting/ScriptPrefixes...‌

What is a Mapping Load in Qlikview