topic Left Join Table in QlikView

Left Join Table

chrisk44 — Sun, 07 Apr 2019 08:09:47 GMT

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 — Mon, 08 Apr 2019 18:01:53 GMT

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

marcus_sommer — Tue, 09 Apr 2019 10:42:50 GMT

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