Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Purushothaman
Partner - Creator III
Partner - Creator III

Difference between Mapping load & Applymap

Hi Experts!

What is the difference between Mapping load & Applymap?

Please help!

Thank you!

Labels (1)
1 Solution

Accepted Solutions
Lisa_P
Employee
Employee

They go together. First you create a mapping table, by prefixing the load statement of your mapping table with the mapping prefix.   Mapping load ....;

This mapping table is then available for lookup using the ApplyMap function in the destination table.

A few rules:

 - Only 2 fields in a mapping table

 - 1st field is the one looked up, 2nd field is returned if there is a match

 - Mapping table must have a name so you can point to that table using the ApplyMap function

View solution in original post

2 Replies
Lisa_P
Employee
Employee

They go together. First you create a mapping table, by prefixing the load statement of your mapping table with the mapping prefix.   Mapping load ....;

This mapping table is then available for lookup using the ApplyMap function in the destination table.

A few rules:

 - Only 2 fields in a mapping table

 - 1st field is the one looked up, 2nd field is returned if there is a match

 - Mapping table must have a name so you can point to that table using the ApplyMap function

Vicky_Z
Support
Support

You may take a look at this post

 

what is mapping load and apply map?