Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hello
am trying to join a table that uses the GENERIC LOAD FUNCTION to another table how can I achieve this.
load
part,
delivery_date,
next_delivery_date
from abc;
left join Generic Load
part,
Qty,
Location
From xyz ;
table1:
LOAD part,
delivery_date,
next_delivery_date
From abc;
table2:
Generic
LOAD part,
Qty,
Location
From xyz;
FOR i = NoOfTables()-1 to 0 STEP -1
LET vTable=TableName($(i));
IF WildMatch('$(vTable)', 'table2.*') THEN
LEFT JOIN (table1) LOAD * RESIDENT [$(vTable)];
DROP TABLE [$(vTable)];
ENDIF
NEXT i
hope this helps
Marco
Hi, Generic creates different tables, one for each attribute, wich should be the 2nd field of the load.
Take a look at this blog post to understand what generic does: https://community.qlik.com/t5/Qlik-Design-Blog/The-Generic-Load/ba-p/1473470
Instead on doing a left join with CombinedGenericTable, do the left join with your main table.
table1:
LOAD part,
delivery_date,
next_delivery_date
From abc;
table2:
Generic
LOAD part,
Qty,
Location
From xyz;
FOR i = NoOfTables()-1 to 0 STEP -1
LET vTable=TableName($(i));
IF WildMatch('$(vTable)', 'table2.*') THEN
LEFT JOIN (table1) LOAD * RESIDENT [$(vTable)];
DROP TABLE [$(vTable)];
ENDIF
NEXT i
hope this helps
Marco
Thanks Marco