Discussion Board for collaboration on QlikView Scripting.
I got problem with joining 2 tables:
1 - TABLE:
2 - TABLE
3 - Destination table
[TABLE_2]:load DATE_T2, NO_T2from ...
left join (TABLE_2)loadKlucz2Resident TABLE1whereNO_T2=NO_T1
and DATE_T2 >= DATE_FROM_T1and DATE_T2 <= DATE_TO_T1
however got error:
field not found NO_T2 (etc. for each field from table 2)
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;