Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Experts!
What is the difference between Mapping load & Applymap?
Please help!
Thank you!
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
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