Joins

[#1]

Hi,

what are the types of joins with examples.

@Sub2u

[#2]

go through this linked file

Joins and Lookups.pdf

[VishalWaghole]

Hi,

Left Join

Right Join

Outer Join

If you not mention any join then qlikview automatically find same column name and join them

Outer join is default join in QlikView.

-- Regards,

Vishal Waghole

[#4]

Thanks Vishal

[#5]

Thanks Bhawna

[#6]

Bhawna,

I am trying to download, but it was getting error. colud please reattach once....

@Sub2u

[#7]

Vishal,

Can u please explain with one example if possible...

I hope there is no equi join, then how will you get common columns from both the tables ....

@Sub2a

[VishalWaghole]

Hi,

Please have look at this image, this will help you to understand join in QlikView.

-- Regards,

Vishal Waghole