Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join us for a live Q&A! September 21, 10 AM ET - Onboarding Fast in Qlik Sense SaaS! REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
intervigilium
Contributor III
Contributor III

Simple join of two resident tables

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.....

1 Solution

Accepted Solutions
vinieme12
Champion II
Champion II

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

View solution in original post

8 Replies
sdmech81
Specialist
Specialist

HI,

Please send the excel data.

Not applicable

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
Specialist
Specialist

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
Champion II
Champion II

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

View solution in original post

Not applicable

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
Specialist
Specialist

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
Master II
Master II

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

intervigilium
Contributor III
Contributor III
Author

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!