Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Concatenation

how to concatenate multiple tables within the one table.

Thanx & Regard,

Qliker.

6 Replies
oknotsen
Master III
Master III

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

Concatenate(tableNameToConcatenateTo)

May you live in interesting times!
Not applicable
Author

I didnt get.

I want to concatenate four tables.

briancopple
Creator II
Creator II

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
Specialist
Specialist

Hi,

Do like this

for example:-

T1:

Load

PRODUCT,

SALES,

AREA

FROM.....

CONCATENATE(T1)

T2:

LOAD

S.NO,

PRODUCT

SALES,

DATE


FROM.....


Regards

briancopple
Creator II
Creator II

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
Master III
Master III

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.

May you live in interesting times!