Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How does auto concatenation work in QlikView?

Hi all,

How does auto concatenation work in QlikView? I understand when two or more tables in QlikView have exactly the same fields, they are automatically concatenated.

Do you have to be in following order of each other, or does QlikView concatenate them even if they are in different places/script tabs etc?

9 Replies
MK_QSL
MVP
MVP

Fields need not to be in same order....!!

Clever_Anjos
Employee
Employee

  • Fields must have same name (case sensitive)
  • Order does not count
Not applicable
Author

Thanks Manish, do tables have to be in following order of each other? If two tables that had the same fields but in different tabs or not following each other on a list in a script, would they still be concatenated?

ThornOfCrowns
Specialist II
Specialist II

Tables with the same field names will be concatenated no matter where they occur.

Clever_Anjos
Employee
Employee

Script tab does not affect concatenation. They´re only to help you organize your code.

"If two tables that had the same fields but in different tabs or not following each other on a list in a script, would they still be concatenated?" yes, they will

its_anandrjs

Only same names of the fields in the table requires some like

Load

Field1,

Field2,

Field3

From Location;

Load

Field2,

Field3,

Field1

From Location;

Result table is one with Field1,Field2,Field3 this fields

MK_QSL
MVP
MVP

Try below script and press CTRL + T after reload.... you will get your answer 🙂

A:

Load * Inline

[

  Customer, Sales

  A,100

  B,200

];

B:

Load * Inline

[

  Customer, Country

  A, Germany

  B, UK

  C, France

];

C:

Load * Inline

[

  Customer, Sales

  C, 2000

];

Not applicable
Author

Thank you guys for helping me understand

datanibbler
Champion
Champion

Hi Michael,

you can have the tables on different tabs - if there is no table inbetween, that is no issue at all. If there is - or might be if anyone else meddles with it - you can specify the name of the table to concatenate to - that's not automatic concatenation anymore then, but still .. That's what I would do, just in case - and in addition, what I do to account for the possibility of anybody else messing around in my scripts, I name them "01_tab1" and "02_tab2" so that it's clear that the tabs have to be in a specific order.