Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Apply Map Issue

Hello

I am trying to do an apply map please tell me how do I use apply map correctly.

Table1:

Load

ID,

Field2,

Field3

;

TableMap:

Mapping Load

Name,

New ID

;

Table2:

Load

Name,

New ID,

Field5

;

2 Replies
maxgro
MVP
MVP

applymap is like a decod or lookup

1) define a map table with 2 fields (first field for input, second for output, names of fields doesn't matter)

with mapping load

2) use ApplyMap('nameofmappingtable', inputfield) to get outputfield from inputfield;

if inputfield matches one value of first field in mapping table, you get the value of the second field in mapping table

MapTable:

mapping load * inline

[

from,to

1,a

2,b

3,c

4,d

];

Table1:

load

  inputfield,

  ApplyMap('MapTable', inputfield) as outputfield;

load * inline

[

inputfield

1

2

3

4

5

6

];

1.png

hic
Former Employee
Former Employee

In Table2 you need to have

     Applymap('TableMap',ID) as [New ID]

HIC