1 Reply Latest reply: Dec 5, 2012 6:45 AM by Gysbert Wassenaar RSS

    Inner Join question

    James Shenton



      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?


      Many thanks