Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for DI and DA gurus. Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor III
Contributor III

what is the benifit of automatic concatenation ?

Please tell me anyone.

Regards,

Hussain.

2 Replies
Highlighted

Re: what is the benifit of automatic concatenation ?

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

Highlighted
MVP
MVP

Re: what is the benifit of automatic concatenation ?

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.