Problem
-----------
How to handle mapping using a combination of a formula and a translation table.
Solution
-----------
The translation table can be used for exceptions to a formula driven relationship. For example, your partner
may be transmitting store numbers to you via the N104. If the store numbers are 1000,1001,1002 etc and
your customer numbers are the result of concatenating “A0” to the beginning of the store number then a
formula can be used to generate the proper customer number. The formula would be “A0” + |currelem|. So,
in our example the resulting customer numbers would be A01000, A01001, A01002.
However, you may have one or two customer numbers that don’t conform to this algorithm. For example,
store number 1003 may represent customer A11003 instead of A01003. In this instance you could set up a
translation table entry to handle this exception. The entry in the “FROM” entry would be A01003 (the
result of your formula) and the “TO” entry would be A11003.
The translator first executes the formula and then checks the translation table. This is why the result of the
formula is added to the table.