topic Re: Generic load in App Development

Generic load

Ayden — Fri, 03 Dec 2021 04:11:58 GMT

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 ;

Re: Generic load

rubenmarin — Fri, 03 Dec 2021 07:48:11 GMT

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.

Re: Generic load

MarcoWedel — Fri, 03 Dec 2021 17:16:50 GMT

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

Re: Generic load

Ayden — Sat, 04 Dec 2021 15:16:02 GMT

Thanks Marco