
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Generic load
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

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi Satish,
Have a look at below post.
http://community.qlik.com/blogs/qlikviewdesignblog/2014/03/31/generic
Regards
ASHFAQ


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
