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: 
gerhardl
Creator II
Creator II

Match fields and add to table

Hi,

If I am loading from two separate tables and they have one matching field, how do I add a new field to the second table using data from the first?

So:

Table 1 - Field A and B

Table 2 - Field A

I need to add Field B to Table 2.

Example:

Table 1:  

Field AField B
12345xyz
4444aaa
5555bbb
6666ccc

Table 2:

Field AADD NEW FIELD HERE
12345xyz
7777
8888
9999


Thanks,

G

2 Replies
Not applicable

try this

table2:

load

     field_A

from ...

table1:

left join

load

     field_A

     field_B

from...

where exits(field_A)

Not applicable

Please see attached file.

It's working in this case.