Join on Dates

T_Qlik — Tue, 03 Oct 2023 08:32:55 GMT

Is there any alternate/optimized way (Maybe Interval match?) to achieve same result. I managed to get the result using below script but reload time is close to 35 minutes.

MainTable : 10 million rows

Table2 : 2.5 million rows

Temp:
Load
AutoNumberhash256([ID1],DATE1) as Key,
[Order number],
DATE1
RESIDENT MainTable
Where match([Status],'QW','PP');

left join (Temp)

Table2:
Load *,
AutoNumberhash256([ID2],DATE2) as Key;
Load
ID2,
DATE(FLOOR(DATE2),'M/D/YYYY') as DATE2,
Price
;

select * from table2;

topic Join on Dates in App Development

Join on Dates