Skip to main content

Suggest an Idea

Vote for your favorite Qlik product ideas and add your own suggestions.

Mapping table with n columns

colombari-g
Contributor III
Contributor III

Mapping table with n columns

It would be great if we could have mapping table with one key column and n value column (instead of only one currently)

Of course, a new parameter should be added in the applymap function to define which value column should be used .

 

Example

mapping

mMultiple:

key, value1, value2, value3

1, AA, BB, CC

2, AA, DD, EE

...

 

applymap('mMultiple', myKey,value1) as field1,

applymap('mMultiple', myKey,value2) as field2,

3 Comments
rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

Is this functionality already provided by the Lookup() function?

https://help.qlik.com/en-US/sense/November2021/Subsystems/Hub/Content/Sense_Hub/Scripting/InterRecor...

Lookup is not as fast as ApplyMap, but it does provide the ability to specify the field. 

Meghann_MacDonald

From now on, please track this idea from the Ideation portal. 

Link to new idea

Meghann

NOTE: Upon clicking this link 2 tabs may open - please feel free to close the one with a login page. If you only see 1 tab with the login page, please try clicking this link first: Authenticate me! then try the link above again. Ensure pop-up blocker is off.

Ideation
Explorer II
Explorer II
 
Status changed to: Closed - Archived