topic Tables in a Qlikview Script in QlikView

Tables in a Qlikview Script

Thu, 26 Aug 2010 16:59:21 GMT

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.

Tables in a Qlikview Script

Miguel_Angel_Baeyens — Thu, 26 Aug 2010 17:12:47 GMT

Hello Yimen,

Use something like

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

Hope that helps!

Tables in a Qlikview Script

Thu, 26 Aug 2010 17:13:33 GMT

Something like this:


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

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

Re. :Re: Tables in a Qlikview Script

Thu, 26 Aug 2010 17:31:06 GMT

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.

Re. :Re: Tables in a Qlikview Script

Thu, 26 Aug 2010 17:41:50 GMT

Please Nick Bor, my tables contain data already.

Thanks for your help

Re. :Re: Tables in a Qlikview Script

Thu, 26 Aug 2010 17:53:47 GMT

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.

Re. :Re: Re. :Re: Tables in a Qlikview Script

Thu, 26 Aug 2010 18:05:47 GMT

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

Re. :Re: Re. :Re: Tables in a Qlikview Script

Thu, 26 Aug 2010 19:58:33 GMT

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