Difference between Mapping load & Applymap

[Purushothaman]

Hi Experts!

What is the difference between Mapping load & Applymap?

Please help!

Thank you!

[Lisa_P · Accepted solution]

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]

You may take a look at this post

what is mapping load and apply map?