Discussion board where members can get started with Qlik Sense.
I'm working with the Mapping group of features, and I've found a small problem that I'd like to solve, maybe helping pointing out it.
Hovever, here the situation: I have this table, that has clearly a pair of mistakes.
And the red Label occurency are wrong, so I decided to remove them and adding the right Labels with a mapping (applied before the table):
Mapping Load Old, New Inline
MAP Label.Key Using Mapping;
Unluckily the result is not perfect, because the mapping maps only the field Label.Key without mapping Label.Key&Name.
I'd like also the Label.Key part of the Label.Key&Name mapped.
I've tried something like:
Applymap(Mapping, Old, Label.Key)&Name
But I got an error that says:
ApplyMap error: map_id not found
How could I make it work?
Thanks in advance
Go to Solution.
LOAD *,ApplyMap('Mapping',Label.Key)&Name as NewName Inline [ Label.Key, Name 'A','first' 'FI','second' 'CP','third' 'RM','fourth' ];
that's the right answer.