Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Nov. 20th, Qlik Insider - Lakehouses: Driving the Future of Data & AI - PICK A SESSION
cancel
Showing results for 
Search instead for 
Did you mean: 
livio218526
Creator
Creator

Mapping table

Hi Everyone,

It's possible create a mapping table with more of 2 columns?

Thanks,

Livio

6 Replies
YoussefBelloum
Champion
Champion

Hi,

No you can't ! a mapping table contains always only 2 columns

Mapping ‒ QlikView

shraddha_g
Partner - Master III
Partner - Master III

YoussefBelloum
Champion
Champion

when you say yes, you talk about "applymap" and not mapping table ?

shraddha_g
Partner - Master III
Partner - Master III

In applymap, if you see link mentioned,

you can concatenate multiple field into one and then used in Mapping Load.

So in short Mapping load allows only 2 columns.

but alternative for Multiple Mapping Tables is combining Multiple columns and putting as one in Mapping  Load.

And in Applymap() you can use Subfield to separate one column into multiple fields

YoussefBelloum
Champion
Champion

Smart ! i thought you really put more than two fields on the mapping table

shraddha_g
Partner - Master III
Partner - Master III

It won't work right..