topic Re: Left Outer join in Qliksense in Visualization and Usability

Left Outer join in Qliksense

Anonymous — Fri, 07 Jul 2017 09:42:55 GMT

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

Re: Left Outer join in Qliksense

arvind_patil — Fri, 07 Jul 2017 09:45:18 GMT

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

Re: Left Outer join in Qliksense

Anonymous — Fri, 07 Jul 2017 10:09:13 GMT

HI Arvind,

this is also throughing error

Re: Left Outer join in Qliksense

Anonymous — Fri, 07 Jul 2017 10:29:41 GMT

does the script work without left join?

Re: Left Outer join in Qliksense

Anonymous — Fri, 07 Jul 2017 10:31:36 GMT

yes, it worked successfully in loading data into individual tables

now i am trying to load data with left join

Re: Left Outer join in Qliksense

Anonymous — Fri, 07 Jul 2017 10:33:05 GMT

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

Re: Left Outer join in Qliksense

Anonymous — Fri, 07 Jul 2017 10:33:30 GMT

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

Re: Left Outer join in Qliksense

Anonymous — Fri, 07 Jul 2017 10:35:25 GMT

perhaps

FROM HIVE.`schemaname`.`emptable`;

Left join

Re: Left Outer join in Qliksense

Anonymous — Fri, 07 Jul 2017 10:35:51 GMT

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

Re: Left Outer join in Qliksense

Anonymous — Fri, 07 Jul 2017 13:19:53 GMT

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

Re: Left Outer join in Qliksense

Anonymous — Fri, 07 Jul 2017 13:24:18 GMT

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