Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 A | Field B |
---|---|
12345 | xyz |
4444 | aaa |
5555 | bbb |
6666 | ccc |
Table 2:
Field A | ADD NEW FIELD HERE |
---|---|
12345 | xyz |
7777 | |
8888 | |
9999 |
Thanks,
G
try this
table2:
load
field_A
from ...
table1:
left join
load
field_A
field_B
from...
where exits(field_A)
Please see attached file.
It's working in this case.