Generic load

[#1]

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

[ashfaq_haseeb]

Hi Satish,

Have a look at below post.

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

Regards

ASHFAQ

[ecolomer]

See this ...

What is Generic load and when we used Generic load.

[#4]

Hi Sathish,

Plz. go thru this link

Generic Load

Regs

Ram

[#5]

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