Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Live Chat, June 29th 10AM ET. Bring your Qik Sense Enterprise, Client Managed questions! REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Architect
Creator
Creator

JOIN explanation

I have used the below logic to create a join table.

tab1:
load *
inline
[
a
1,
2,
3,
4
];

inner join

tab2:
load *
inline
[
b
5,
6,
7
];

Below is the output--

Architect_0-1620028489363.png

Can someone please explain with logic why is so.

Thanks in advance.

Labels (1)
1 Solution

Accepted Solutions
MayilVahanan

HI @Architect 

Both tables doesn't have common field, so explicitly you have used join.

In that case, it using cross join. 

If you have any common field, then its do inner join.

Thanks & Regards,
Mayil Vahanan R

View solution in original post

1 Reply
MayilVahanan

HI @Architect 

Both tables doesn't have common field, so explicitly you have used join.

In that case, it using cross join. 

If you have any common field, then its do inner join.

Thanks & Regards,
Mayil Vahanan R

View solution in original post