Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Let two tables TAB1 and TAB2.
TAB1 is defined with three fields as: TAB1(f1, f2, f3)
TAB2 is defined with two fields as: TAB2(g1, g2)
Please, Is there a Qlikview functions that allows to merge the two table to get a table TAB3 defined as : TAB3(f1, f2, f3, g1,g2)
Thanks.
Hello Yimen,
Use something like
Tab3:LOAD * RESIDENT TAB1; CONCATENATE LOAD * RESIDENT TAB2;
Hope that helps!
Something like this:
TAB3:
load * inline [
f1, f2, f3
1,2,3
11,22,33
];
concatenate
load * inline [
g1, g2
111,222
1111,2222
];
Now, the script runs entirely.
I want to map TAB3 to an Table Object of Qlikview. But when i want to select the table TAB3 in the select fields in the box of properties in tab General, TAB3 dont appears.
Must i delete TAB1 and TAB2?
I don't know why the table TAB3 don't appears.
Please Nick Bor, my tables contain data already.
Thanks for your help
It doesn't matter. It is an example. You can use the approach suggested by Miguel, but with this small changes:
<pre>Tab3:
noconcatenate
LOAD *
RESIDENT TAB1;
CONCATENATE LOAD *
RESIDENT TAB2;
Otherwise TAB1 will be auto-concatenated to itself and table name Tab3 will be ignored.
In fact, i have remarked that, CONCATENATE add the record of the second table at the end of first table
and JOIN do the combination of data.
But what i want is:
To join end to end the two tables with theirs data.
Thanks
In the case you should tell us how these two tables related to each other. Otherwise you can get a Cartesian expression.