Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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