Inner Join question

[#1]

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

[Gysbert_Wassenaar]

Not really. You could use the lookup function, but you'd still need to load both tables to be able to lookup F2 from T1. The way you do it now is probably the better option.