Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
There is any possibility to do Non-Equi Join operation (unlike Inner) in QlikView.
I'm expecting keyword like Left join, Right join, Outer join.
Regards,
Nihhal.
Thank you Jonathan.
I achieved this by these steps.
1. Outer join
2. Resident load outer join table with where key1<>key2.
Regards,
Nihhal.
Yes all does keywords exists, please see help in QV Desktop
Is it available Non-Equi Join in QlikView? For all i know there is no non-equi join in QV.
If by non-equi join you mean a SQL join clause on an inequality( <>, <, >), then no, there no direct equivalent in QV. However, you can usually achieve it using an extra resident load.
Thank you Jonathan.
I achieved this by these steps.
1. Outer join
2. Resident load outer join table with where key1<>key2.
Regards,
Nihhal.