10 Replies Latest reply: Jul 7, 2017 9:24 AM by Robin Hausdörfer RSS

    Left Outer join in Qliksense

    nagamani vadisala

      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