Tables in a Qlikview Script

[#1]

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.

[Miguel_Angel_Baeyens]

Hello Yimen,

Use something like

Tab3:LOAD * RESIDENT TAB1; CONCATENATE LOAD * RESIDENT TAB2;

Hope that helps!

[#3]

Something like this:

TAB3:
load * inline [
f1, f2, f3
1,2,3
11,22,33
];

concatenate
load * inline [
g1, g2
111,222
1111,2222
];

[#4]

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.

[#5]

Please Nick Bor, my tables contain data already.

Thanks for your help

[#6]

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.

[#7]

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

[#8]

In the case you should tell us how these two tables related to each other. Otherwise you can get a Cartesian expression.