topic Generic load in QlikView

Generic load

Sun, 17 Aug 2014 11:03:49 GMT

Hi Community,

I need a clarification on generic load along with perfect example.How it helpful in real time?.

Can anyone help me out in detail.

Thanks in advance

Regards,

Satish G

Re: Generic load

ashfaq_haseeb — Sun, 17 Aug 2014 11:06:03 GMT

Hi Satish,

Have a look at below post.

http://community.qlik.com/blogs/qlikviewdesignblog/2014/03/31/generic

Regards

ASHFAQ

Re: Generic load

ecolomer — Sun, 17 Aug 2014 12:36:02 GMT

See this ...

What is Generic load and when we used Generic load.

Re: Generic load

Sun, 17 Aug 2014 17:28:34 GMT

Hi Sathish,

Plz. go thru this link

Generic Load

Regs

Ram

Re: Generic load

Mon, 18 Aug 2014 04:24:26 GMT

Thanks for sharing!!!

Can anyone explain in detail in the below marked(bold) script? Because i can't understand here!!! Request to help me out

Table1:

load * inline [

ID,name,type,value

1,A,blue,10

1,A,yellow,50

3,C,red,80

3,C,yellow,60

4,D,yellow,40

];

Table2:

generic load *

resident Table1;

ResultTable:

LOAD Distinct ID, name Resident Table1;

FOR i = 0 to NoOfTables()

TableList:

LOAD TableName($(i)) as Tablename AUTOGENERATE 1

WHERE WildMatch(TableName($(i)), 'Table2.*');

NEXT i

FOR i = 1 to FieldValueCount('Tablename')

LET vTable = FieldValue('Tablename', $(i));

LEFT JOIN (ResultTable) LOAD * RESIDENT [$(vTable)];

DROP TABLE [$(vTable)];

NEXT i

Drop Tables Table1, TableList;

Thanks in advance!!!

Regards,

Satish G