Simple join of two resident tables

[intervigilium]

I have some data that i "convert" using crosstable functionality.

The result is 2 resident tables which i want to combine. Both tables have 8 the same fields en 2 different.

Normally i would expect a regular (outer) join would do the trick, but nothing happens...

Tussentabel1:

LOAD Land,

     Provincie,

     Gemeente

FROM

(ooxml, embedded labels, table is Tabel1);

Tussentabel2:

LOAD Land,

     Provincie,

     Stad

FROM

(ooxml, embedded labels, table is Tabel2);

Samenvoeging:

Load *

RESIDENT Tussentabel1;

Join

Load *

Resident Tussentabel2;

Drop Table Tussentabel1;

Drop Table Tussentabel2;

But afterwards he dropped both tables, but the new table "Samenvoeging" is not created.... What am i doing wrong?

It Looks so simple.....

[sdmech81]

HI,

Please send the excel data.

[#3]

Hi Frido

Try This

Tussentabel1:

LOAD Land,

     Provincie,

     Gemeente

FROM

(ooxml, embedded labels, table is Tabel1);

Join(Tussentabel1)

LOAD Land,

     Provincie,

     Stad

FROM

(ooxml, embedded labels, table is Tabel2);

[sdmech81]

I think problem is tht you have 8 similar filed and join is happening based on all 8 filed.

Identify the filed based on which u want to join and alias rest of the fieleds..

[vinieme12 · Accepted solution]

because your fieldnames are the same Qlikview will auto concatenate both tables, just try as below

Tussentabel1:

LOAD Land,

     Provincie,

     Gemeente

FROM

(ooxml, embedded labels, table is Tabel1);

Join

Tussentabel2:

LOAD Land,

     Provincie,

     Stad

FROM

(ooxml, embedded labels, table is Tabel2);

[#6]

Otherwise use this

Tussentabel1:

LOAD Land,

    Provincie,

    Gemeente

FROM

(ooxml, embedded labels, table is Tabel1);

Tussentabel2:

LOAD Land,

    Provincie,

    Stad

FROM

(ooxml, embedded labels, table is Tabel2);

Samenvoeging:

Noconcatenate Load *

RESIDENT Tussentabel1;

Join (Samenvoeging)

Load *

Resident Tussentabel2;

Drop Table Tussentabel1;

Drop Table Tussentabel2;

The reason is your Samenvoeging will concatenate with Tussentabel1. (Because all the field names are the same)

Kind Regards

[sdmech81]

Yes but why do want to join them after loading you can directly join them while loading and store them.

As told by vinith,ur filed names are same it will auto concatenate.

Still u want to do say no concatenate between above tables then do.

[buzzy996]

just add "Noconcatenate" keyword before start of ur samenvoeging table load script and see?

[intervigilium]

Hi all,

Thanks for all help! your input helped a lot!

Sorry for the slow response. Direct after implementing the solution some not foreseen events happened, so the feedback took some time.

Greetings!