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.
this is a weird question
not even sure if I can do this
lets say I have 2 dbs.. and 2 tables
but both have the same data types in it.. like product/prod info/prod pic/etc
same header names...
but db1 has info from yr 1 - 5
db2 has yr 6-future
how do I combine them on one qv and make it show seamlessly all products from yr 1 - future?
I tried just putting it in one load and naming both the same and it gave me a loop error
If the structure of both tables is the same, you should concatenate the two tables:
'A' as Source
'B' as Source
Note that QV will autoconcatenate tables with same name and number of fields, CONCATENATE will make it more explicite and also force concatenation if structure is not 100% the same.
View solution in original post
this works.. kinda
can u concatenate 4 tables together?
I did 2 and it works.. but when I add 3 and 4.. I don't get the extra data..
not sure why
Concatenation also works with multiple tables.
How does your script look like?
Does the other two tables has same number of fields and hope you are using Concatenage(PRODUCT) between all the tables ?
@Stefan and vish
yes I was not concatenating the right amount of fields.. db 3 had one (matching field).. and db 4 had 2 matching fields
I needed to join 2,3,4 together then concatenate