Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Left Outer join in Qliksense

I am successfull in loading individual tables data through script in Qlik Sense.

When I am trying to define left our join, i am getting error. I tried as below

LOAD name,

   `emp_no`;

SQL SELECT name,

      no as `emp_no`

ROM HIVE.`schemaname`.`emptable`

left outer join

LOAD `dept_no`

  `emp_no`

SQL SELECT dept_no,

      emplno as 'emp_no'

ROM HIVE.`schemaname`.`depttable` ;

But above qury got error, can anyone please help

10 Replies
Anonymous
Not applicable
Author

perhaps you have no matching key because of qualify statement...

I don't know how many rows you're loading.

perhaps load without "left join" and post a screnshot of your data model