Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
how to concatenate multiple tables within the one table.
Thanx & Regard,
Qliker.
Add this line directly above the LOAD statement in your script:
Concatenate(tableNameToConcatenateTo)
I didnt get.
I want to concatenate four tables.
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
Hi,
Do like this
for example:-
T1:
Load
PRODUCT,
SALES,
AREA
FROM.....
CONCATENATE(T1)
T2:
LOAD
S.NO,
PRODUCT
SALES,
DATE
FROM.....
Regards
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.
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.