topic Re: which join it will consider? in QlikView

which join it will consider?

Thu, 10 Sep 2015 11:24:17 GMT

1.One table having 10(1-10) fields, second table having 10(11-20) fields, in between these 2 tables we are not using any command then which join it will take?

2. If I am having 2 tables like A and B, if I used the command called join, then by default which join it will consider in qlikview?

Re: which join it will consider?

gautik92 — Thu, 10 Sep 2015 11:25:17 GMT

by default it will take outer join

Re: which join it will consider?

sunny_talwar — Thu, 10 Sep 2015 11:27:13 GMT

1) If you don't specify the word join and the field names are all common between the two tables, then it will concatenate (and not join)

2) it will be an outer join

Re: which join it will consider?

PrashantSangle — Thu, 10 Sep 2015 11:28:26 GMT

Hi,

if both table having same field then concatenate

Regards

Re: which join it will consider?

qlikmsg4u — Thu, 10 Sep 2015 11:28:30 GMT

1. If these two tables has same field names then they concatenated automatically

2.If u specify keyword join then it will be Outer Join