Concatenation

[#1]

how to concatenate multiple tables within the one table.

Thanx & Regard,

Qliker.

[oknotsen]

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

Concatenate(tableNameToConcatenateTo)

[#3]

I didnt get.

I want to concatenate four tables.

[Anonymous]

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

[qlikview979]

Hi,

Do like this

for example:-

T1:

Load

PRODUCT,

SALES,

AREA

FROM.....

CONCATENATE(T1)

T2:

LOAD

S.NO,

PRODUCT

SALES,

DATE

FROM.....

Regards

[Anonymous]

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.

[oknotsen]

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.