In the load script I am loading two tables with an inner join. I want to derive a field that is calculated from one field in the first table and one from the second.
For example, if the script was like this:
LOAD F1,F2 FROM T1
LOAD F1,F3,F4 FROM T2
I want to create a new field that is F2 + '|' + F4
What I can easily do is to create the table with the inner join, then create a new table with the extra field and then drop the first table. But there must be an easier way, in which I can just create the extra field in one step?