Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
How to add multiple columns in apply map in qliksense ?
Can you be more specified?
Usually an ApplyMap works like:
MappingTale:
Mapping
Load
KeyField,
MapField
From MapQvd.qvd(qvd);
Table:
Load
ApplyMap('MappingTale',KeyField) as MappedField,
...,
From Table.qvd(qvd);
more than 2 columns or 3 col
You can add multiple ApplyMap in the same load according to the amount of data you have to map
how to write any example
FirstMappingTale:
Mapping
Load
KeyField1,
MapField1
From FirstMapQvd.qvd(qvd);
SecondMappingTale:
Mapping
Load
KeyField2,
MapField2
From SecondMapQvd.qvd(qvd);
ThirdMappingTale:
Mapping
Load
KeyField3,
MapField3
From ThirdMapQvd.qvd(qvd);
Table:
Load
ApplyMap('FirstMappingTale',KeyField1) as MappedField1,
ApplyMap('SecondMappingTale',KeyField2) as MappedField2,
ApplyMap('ThirdMappingTale',KeyField3) as MappedField3,
...,
From Table.qvd(qvd);