topic Re: SQL vs Qlikview join are Same? in QlikView

SQL vs Qlikview join are Same?

prma7799 — Thu, 25 Jul 2019 09:00:01 GMT

Hello Expert ,

I am doing join in SQL server and i am getting below output.

But when I have done this in qlikview with same data my Output will be different means i am getting only one column 'X'

X:
Load * Inline [
X
1
0
1
0
];
left join
Y:
LOAD * Inline [
X
1
0
1
0
];

Please reply on this...

prma7799 — Thu, 25 Jul 2019 10:06:08 GMT

Anyone can look into this ...

Or — Thu, 25 Jul 2019 10:31:44 GMT

Brett_Bleess — Mon, 19 Aug 2019 21:25:04 GMT

Have a look at the following Design Blog post as well, may shed some further light upon things:

And just in case, here is Help link which may help as well:

Regards,
Brett