Left Join Table

chrisk44 · ‎2019-04-07

I got problem with joining 2 tables:

1 - TABLE:

2 - TABLE

3 - Destination table

I've tried:

[TABLE_1]:

load DATE_FROM_T1,DATE_TO_T1,NO_T1,KEY_T1

from...

[TABLE_2]:
load DATE_T2, NO_T2
from ...

left join (TABLE_2)
load
Klucz2
Resident TABLE1
where
NO_T2=NO_T1

and DATE_T2 >= DATE_FROM_T1
and DATE_T2 <= DATE_TO_T1

however got error:

field not found NO_T2 (etc. for each field from table 2)

Please help.

NhanNguyen · ‎2019-04-08

Try to rename NO_T2 as NO_T1 if you don't specify on the key fields

marcus_sommer · ‎2019-04-09

You need to do at first some kind of intervalmatching before you could join the tables, for example with something like this:

t1: load date(FROM + iterno() - 1) as DATE, NO, KEY from t1 while FROM + iterno() - 1 <= TO;
right join(t1) load DATE, NO from t2;

- Marcus

Related Topics