It would be great if we could have mapping table with one key column and n value column (instead of only one currently)
Of course, a new parameter should be added in the applymap function to define which value column should be used .
Example
mapping
mMultiple:
key, value1, value2, value3
1, AA, BB, CC
2, AA, DD, EE
...
applymap('mMultiple', myKey,value1) as field1,
applymap('mMultiple', myKey,value2) as field2,