Discussion board where members can get started with Qlik Sense.
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
SQL SELECT name,
no as `emp_no`
left outer join
SQL SELECT dept_no,
emplno as 'emp_no'
ROM HIVE.`schemaname`.`depttable` ;
But above qury got error, can anyone please help
Please Try This One:
this is also throughing error
does the script work without left join?
yes, it worked successfully in loading data into individual tables
now i am trying to load data with left join
trying as below now:
could you post a screenshot of your data model without lefr join?
This is script ot load indiviual tables and this is successful
FROM HIVE.`schemaname`.`depttable` ;
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