Discussion Board for collaboration on QlikView Scripting.
load * inline [
generic load *
--can any body give explination of this script .i am am new to qlik view
LOAD Distinct ID, name Resident Table1;
FOR i = 0 to NoOfTables()
LOAD TableName($(i)) as Tablename AUTOGENERATE 1
WHERE WildMatch(TableName($(i)), 'Table2.*');
FOR i = 1 to FieldValueCount('Tablename')
LET vTable = FieldValue('Tablename', $(i));
LEFT JOIN (ResultTable) LOAD * RESIDENT [$(vTable)];
DROP TABLE [$(vTable)];
Drop Tables Table1, TableList;
Please have a look at
Everything after your comment can be deleted. This code is not really necessary. The code before your comment can be simplified to
Generic Load * Inline
Just run this script and look at the data model. Then you will see that the "Generic" prefix has created one field per color. It has also split the table into one table per color.
All the for-loop in the original script does, is to join the three color tables into one single table - which in most cases isn't necessary.