Join two tables

[camilo]

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!

[nagaiank]

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

Table3:

NoConcatenate LOAD * Resident Table1;

Concatenate (Table3) LOAD * Resident Table2;

[camilo]

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.

[martin59 · Accepted solution]

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

[camilo]

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);

[martin59]

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 !