topic Re: join in QlikView

join

master_student — Wed, 14 Dec 2016 09:51:03 GMT

Hello Guys,

A join in qlikview is equivalent to outer join or inner join?

Thanks

Re: join

mayankraoka — Wed, 14 Dec 2016 09:58:27 GMT

By default it is outer join.Creating all possible combinations of values from thetwo tables.

Prefer to always explicitly state which sort of join you want, even for an outer join. The code is more clear that way.

Regards,

Mayank

Re: join

Anonymous — Wed, 14 Dec 2016 10:09:21 GMT

Hi,

I think....

Outer join is equivalent to join...

because..join is not going to filter the data it just append the both tables fields into single table,if there is any common fields join will merge that filed data and other fields just append into first table.

and

where as in inner join it is going to filter the data based on link filed ,if suppose there no link filed it will treated as a normal join.

and

where as in outer join is not going to filter the data it just append the both the tables as like normal join.