I read a unique key from a resident temp table. I need to store it in a result table and I need to add to each key two different constants into the same field. This will obviously doubled the number of records in the result table.
Now I proceed like this...
'N' as Const
'V' as Const
It is no racket science and I can live with that, but I'm convinced that the result can be achieved with one simple load.
we'd need to know how are the constants stored and the logic behind assigning them to each key before coming up with a technique to apply.
Take into account you can't have 2 different expressións for the same field in the same load, so If you want to code the LOAD only once, it will have to be inside some sort of loop or use a concatenated field with concat(), concatenated ApplyMap(), etc.