topic Re: Merging/Combining data in QV in QlikView

Merging/Combining data in QV

Anonymous — Wed, 18 Jan 2017 22:37:53 GMT

hi all

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

thanks

Re: Merging/Combining data in QV

swuehl — Wed, 18 Jan 2017 22:46:12 GMT

If the structure of both tables is the same, you should concatenate the two tables:

PRODUCT:

LOAD Product,

ProdInfo,

Price,

'A' as Source

FROM TableA;

CONCATENATE (PRODUCT)

LOAD Product,

ProdInfo,

Price,

'B' as Source

FROM TableB;

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.

Re: Merging/Combining data in QV

Anonymous — Thu, 19 Jan 2017 15:00:02 GMT

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

thanks

Re: Merging/Combining data in QV

swuehl — Thu, 19 Jan 2017 15:09:47 GMT

Concatenation also works with multiple tables.

How does your script look like?

Re: Merging/Combining data in QV

vishsaggi — Thu, 19 Jan 2017 15:10:39 GMT

Does the other two tables has same number of fields and hope you are using Concatenage(PRODUCT) between all the tables ?

Re: Merging/Combining data in QV

Anonymous — Fri, 20 Jan 2017 20:37:35 GMT

@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

thanks all