topic Re: Natural Join? in QlikView

Natural Join?

Fri, 23 May 2014 04:20:13 GMT

Hello!

The other day I was asking something in the Community because I was needing to create a single table with different dates from different tables and I was recommended to do the following, which actually worked for me:

Link:

Load ACCOUNT_ID, DATE_PLANNED

Resident TableA;

Join

Load ACCOUNT_ID, DATE_CANCELLED

Resident TableB;

Join

Load ACCOUNT_ID, DATE_TESTED, DATE_SENT

Resident TableC;

The thing is that I've never used the Join like that way, I usually use Inner & Left Join.

I wanted to know if that'd be the Natural Join and which is it's goal.

What's the difference to use Concatenate instead of that Join?

Thank you!!!

Re: Natural Join?

Fri, 23 May 2014 05:34:26 GMT

Hi mart pabst,

Joint will match and merge whereas concatenate add data vertically irrespective of matching values.

Eg:

concatenate

table:

LOAD * INLINE [

A, B

1, 1

2, 2

];

table1:

Concatenate

LOAD * INLINE [

];

Ans:

Table:(Takes first table name)

A, B

1, 1

2, 2

Join

table:

LOAD * INLINE [

A, B

1, 1

2, 2

];

table1:

join

LOAD * INLINE [

];

Ans:

Table:(Takes first table name)

A, B

1, 1

2, 2

Thank you

Re: Natural Join?

anbu1984 — Fri, 23 May 2014 05:52:10 GMT

Fullouter join and concatenate

Concatenate,Left Join, Left Keep

Re: Natural Join?

SunilChauhan — Fri, 23 May 2014 06:07:42 GMT

i thing you only neeed to use concatenate between them. if there is no link b/w them

but i wonder there might be link beteen them.

if there is link then use left join,right etc

hope this helps