topic Re: Concatenation in QlikView

Concatenation

Wed, 25 Nov 2020 16:16:04 GMT

how to concatenate multiple tables within the one table.

Thanx & Regard,

Qliker.

Re: Concatenation

oknotsen — Fri, 08 Jul 2016 07:46:30 GMT

Add this line directly above the LOAD statement in your script:

Concatenate(tableNameToConcatenateTo)

Re: Concatenation

Fri, 08 Jul 2016 07:51:37 GMT

I didnt get.

I want to concatenate four tables.

Re: Concatenation

Anonymous — Fri, 08 Jul 2016 07:55:28 GMT

Load * from tableA

Concatenate (TableA)

Load *

from Table B

However if the two tables have the same number of columns and the same column names qlikview will automatically concatenate them unless you tell it not to by using

no concatenate load * from Table B

Kindest Regards

Brian

Re: Concatenation

qlikview979 — Fri, 08 Jul 2016 08:08:16 GMT

Hi,

Do like this

for example:-

T1:

Load

PRODUCT,

SALES,

AREA

FROM.....

CONCATENATE(T1)

T2:

LOAD

S.NO,

PRODUCT

SALES,

DATE

FROM.....

Regards

Re: Concatenation

Anonymous — Fri, 08 Jul 2016 09:39:19 GMT

You just need to load each table and make sure that the second, third and fourth are concatenated to the first.

Table1:

load * from sourcefile1

Concatenate (Table1)

load * from sourcefile2

Concatenate (Table1)

load * from sourcefile3

Concatenate (Table1)

load * from sourcefile4

Hope this makes sense. If you want to share your app and script we may be able to clarify things better.

Re: Concatenation

oknotsen — Fri, 08 Jul 2016 09:42:32 GMT

So do what I suggested for 3 times; for table 2, 3 and 4.

Table1:

Load *

From source;

Table2:

concatenate(Table1)

Load *

From source;

Repeat the last part for table 3 and 4, every time pointing at Table1.