Concatinate two qvd

[#1]

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]

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