Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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