How does auto concatenation work in QlikView?

[#1]

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?

[MK_QSL]

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

[Clever_Anjos]

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

[#4]

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]

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

[Clever_Anjos]

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]

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

];

[#9]

Thank you guys for helping me understand

[datanibbler]

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.