what is the benifit of automatic concatenation ?

[Anonymous]

Please tell me anyone.

Regards,

Hussain.

[rubenmarin]

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

[petter]

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.