Mapping for multiple columns

[New-Qlik]

Hello,

I have a table with millions of data and i have created 4 mapping tables based on that one table. It takes so much time to refresh application as every time those 4 mapping load runs for millions of data. 

Thinking loud but is there any other smart way to do mapping with  multiple columns in one go.

TIA

[tresesco]

Could you explain with an example?

[JordyWegman]

Hi Avneet,

There are multiple possibilities.

1. Do you really need a mapping? Otherwise, use a (left) join
2. Create a mapping with concatenated fields and use SubField for the correct applymap execution

Jordy

Climber