which join it will consider? - Qlik Community

Report Inappropriate Content · ‎2015-09-10

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?

gautik92 · ‎2015-09-10

by default it will take outer join

sunny_talwar · ‎2015-09-10

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

PrashantSangle · ‎2015-09-10

Hi,

if both table having same field then concatenate

Regards

Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

qlikmsg4u · ‎2015-09-10

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