topic Concatinate two qvd in QlikView

Concatinate two qvd

Sun, 10 Oct 2010 11:33:47 GMT

Dear all,

I have two qvd files from 2 different sources. I want to concatinate these two files in full join format as example.

file 1: f1=a,b,c

file 2:f2=1,2,3

I want to have f3 =a1,a2,a3,b1,b2,b3,c1,c2,c3.

How can i do it?

Thank you very much for your help.

mantaq10 — Sun, 10 Oct 2010 21:43:44 GMT

Hi,

this is a simple cross product. i.e. a join without a key.

simply do this:



LOAD F1
FROM
C:\Users\Atif\Desktop\1.qvd
(qvd);

join

LOAD F2
FROM
C:\Users\Atif\Desktop\2.qvd
(qvd);

Greets