Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
by default it will take outer join
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
Hi,
if both table having same field then concatenate
Regards
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