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

    Inner Join question

    James Shenton

      Hello

       

      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

      INNER JOIN

      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

      James