Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

nishanthi_8
Contributor

How Mapping can be used when a column doesnt exist in a table ?

I have two tables concatenated and there doesnt exist a column name in one of the table. How it can be achieved via ApplyMap() ?

DIMENSION TABLE:

USER ID,

ORG SUB_CATEGORY;

CONCATENATE

USER ID,

ORG NAME,

ORG SUB_CATEGORY;

     In the above example i need ORG NAME to be used in ApplyMap() so that ORG SUB_CATEGORY can also be used for further manipulations.

1 Reply
arulsettu
Honored Contributor III

Re: How Mapping can be used when a column doesnt exist in a table ?

like this

maptable:

mapping load

USER ID,

ORG SUB_CATEGORY;

second table:

USER ID,

applymap('maptable',ORG NAME) as orgname,

ORG SUB_CATEGORY;

Community Browser