topic Join two tables in QlikView

Join two tables

camilo — Fri, 08 Jul 2011 22:25:54 GMT

Hi, I think this is very basic, but if someone can help me I would be very gratefull. I want to join two tables with the same fields:

Ex.

Table 1:

A B C

xxx 22 33

Table 2:

A B C

YYY 22 43

And I want to create

Table 3:

A B C

xxx 22 33

YYY 22 43

Thanks for your help!

Re: Join two tables

nagaiank — Fri, 08 Jul 2011 22:33:27 GMT

This is called concatenation. You can do it as follows:

Table3:

NoConcatenate LOAD * Resident Table1;

Concatenate (Table3) LOAD * Resident Table2;

Join two tables

camilo — Wed, 13 Jul 2011 13:48:34 GMT

Hi, I´m trying to use concatenate in the following example but y got an error msg:

Example:

Test1

a	b	c
pepe	10	10
jaime	10	10

Test2

a	b	c
pepe	10	10
camilo	10	10

Then I create the following qvw:

Table1:

LOAD *

FROM

(ooxml, embedded labels, table is Hoja1);

Table2:

LOAD *

FROM

(ooxml, embedded labels, table is Hoja1);

Table3:

NoConcatenate LOAD * Resident Table1;

Concatenate (Table3) LOAD * Resident Table2;

---------------------------

When I load this example I get the following error:

"Table not found

Concatenate (Table3) LOAD * Resident Table2"

Anyway the qvw finish loading with a sinc key (which has all the parameters), and now I have two tables, Table3 and Table1 both equivalents.

Re: Join two tables

martin59 — Wed, 13 Jul 2011 13:54:33 GMT

Hi,

Table2 is already concatenate with table1 because they have the same structure

To simplify, you can do this :

Table1:
LOAD *
FROM
(ooxml, embedded labels, table is Hoja1);
Concatenate (Table1)
LOAD *
FROM
(ooxml, embedded labels, table is Hoja1);

Hope that helps you

Join two tables

camilo — Wed, 13 Jul 2011 15:47:19 GMT

Thanks Martin,

It worked prefectly, just one more question, ¿I can concatenate as many tables as I need, using your answer, as long as they have the same structure?

For example:

Table1: LOAD * FROM (ooxml, embedded labels, table is Hoja1); Concatenate (Table1) LOAD * FROM (ooxml, embedded labels, table is Hoja1);

Concatenate (Table1) LOAD * FROM (ooxml, embedded labels, table is Hoja1);

Join two tables

martin59 — Sat, 16 Jul 2011 10:47:46 GMT

Yes, you can concatenate as many tables you want.

But you can do this :

Table1:

LOAD *

FROM

(ooxml, embedded labels, table is Hoja1);

And you'll load all xlsx files whiwh name begins by "test "

Hope that helps you !