Left Outer join in Qliksense

[Anonymous]

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

[arvind_patil]

HI Nagamani,

Please Try This One:

LOAD name,

   `emp_no`;

SQL SELECT name,

      no as `emp_no`

ROM HIVE.`schemaname`.`emptable`

Left join

LOAD `dept_no`

  `emp_no`

SQL SELECT dept_no,

      emplno as 'emp_no'

ROM HIVE.`schemaname`.`depttable` ;

Thanks,

Arvind Patil

[Anonymous]

HI Arvind,

this is also throughing error

[Anonymous]

does the script work without left join?

[Anonymous]

yes, it worked successfully in loading data into individual tables

now i am trying to load data with left join

[Anonymous]

trying as below now:

leftjointable:

LOAD name,

   `emp_no`;

SQL SELECT name,

      no as `emp_no`

ROM HIVE.`schemaname`.`emptable`

Left join

LOAD `dept_no`

  `emp_no`

SQL SELECT dept_no,

      emplno as 'emp_no'

ROM HIVE.`schemaname`.`depttable` ;

[Anonymous]

could you post a screenshot of your data model without lefr join?

[Anonymous]

perhaps

FROM HIVE.`schemaname`.`emptable`;

Left join

[Anonymous]

This is script ot load indiviual tables and this is successful

LOAD name,

   `emp_no`;

SQL SELECT name,

      no as `emp_no`

FROM HIVE.`schemaname`.`emptable`;

LOAD `dept_no`

  `emp_no`

SQL SELECT dept_no,

      emplno as 'emp_no'

FROM HIVE.`schemaname`.`depttable` ;

[Anonymous]

thanks, this is running. It did not throughed out any error

but running from last 2 hours and still running, how can we move forward on this