Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Inner Join question

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

1 Reply
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.


talk is cheap, supply exceeds demand