Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

manigunta
Contributor

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
arvind_patil
Valued Contributor II

Re: Left Outer join in Qliksense

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

manigunta
Contributor

Re: Left Outer join in Qliksense

HI Arvind,

this is also throughing error

roharoha
Valued Contributor III

Re: Left Outer join in Qliksense

does the script work without left join?

manigunta
Contributor

Re: Left Outer join in Qliksense

yes, it worked successfully in loading data into individual tables

now i am trying to load data with left join

manigunta
Contributor

Re: Left Outer join in Qliksense

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` ;

roharoha
Valued Contributor III

Re: Left Outer join in Qliksense

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

roharoha
Valued Contributor III

Re: Left Outer join in Qliksense

perhaps

FROM HIVE.`schemaname`.`emptable`;

Left join

manigunta
Contributor

Re: Left Outer join in Qliksense

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` ;

manigunta
Contributor

Re: Left Outer join in Qliksense

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

Community Browser