Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Please tell me anyone.
Regards,
Hussain.
Hi, one usual case is when you are loading a bunch of files/tables with the same format, like budgets from different months or reading data from different databases, one for each company but with the same format
For each vFile in filelist(...)
TableName:
LOAD * From [$(vFile)];
NEXT
Anyway, I usually prefer to specify the Concatenate/NoConcatenate keywords and avoid autoconcatenation
Auto concatenation avoids the creation of synthetic keys - so essentially it is in line with how the data model works in a sensible way in Qlik. Meaning that the fields are the important entities in Qlik not the tables. It's the field name that determine the true semantics of the field not the combination of a table plus the column name as it is in relational databases.