This field is required.
Only these extensions are allowed(.jpg, .JPG, .jpeg, .JPEG, .gif, .GIF, .png, .PNG)
Tags cannot contain the characters ' /, \\, #, ?, or ; >,< '
Only these extensions are allowed(.zip,.ZIP,.pdf,.PDF,.qvf,.QVF,.qvw,.QVW)
Discussion Board for collaboration related to QlikView App Development.
how to concatenate multiple tables within the one table.
Thanx & Regard,
Add this line directly above the LOAD statement in your script:
I didnt get.
I want to concatenate four tables.
Load * from tableA
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
Do like this
You just need to load each table and make sure that the second, third and fourth are concatenated to the first.
load * from sourcefile1
load * from sourcefile2
load * from sourcefile3
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.
Repeat the last part for table 3 and 4, every time pointing at Table1.