Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

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

Re: How does auto concatenation work in QlikView?

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

Employee
Employee

Re: How does auto concatenation work in QlikView?

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

Re: How does auto concatenation work in QlikView?

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
Valued Contributor II

Re: How does auto concatenation work in QlikView?

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

Employee
Employee

Re: How does auto concatenation work in QlikView?

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

Re: How does auto concatenation work in QlikView?

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

Re: How does auto concatenation work in QlikView?

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

Re: How does auto concatenation work in QlikView?

Thank you guys for helping me understand

datanibbler
Esteemed Contributor

Re: How does auto concatenation work in QlikView?

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.

Community Browser