topic Re: Difference between Mapping load & Applymap in App Development

Difference between Mapping load & Applymap

Purushothaman — Thu, 17 Feb 2022 03:19:11 GMT

Hi Experts!

What is the difference between Mapping load & Applymap?

Please help!

Thank you!

Lisa_P — Thu, 17 Feb 2022 04:20:52 GMT

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 — Thu, 17 Feb 2022 04:37:32 GMT

You may take a look at this post