Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

Tables in a Qlikview Script

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.

Tags (1)
7 Replies
MVP
MVP

Tables in a Qlikview Script

Hello Yimen,

Use something like

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


Hope that helps!

Not applicable

Tables in a Qlikview Script

Something like this:


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

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


Not applicable

Re. :Re: Tables in a Qlikview Script

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.

Not applicable

Re. :Re: Tables in a Qlikview Script

Please Nick Bor, my tables contain data already.

Thanks for your help

Not applicable

Re. :Re: Tables in a Qlikview Script

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.

Not applicable

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

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

Not applicable

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

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

Community Browser