1 Reply Latest reply: Feb 21, 2018 6:32 PM by Santosh MOTHE RSS

    Loading data from ODBC into Qlik Sense

    Wanyun Yang

      Hi guys,

       

      I'm loading data from ODBC into Qlik Sense. Is it possible to write SQL queries and manipulate things like table joining method when loading data?

       

      Thanks in advance!

        • Re: Loading data from ODBC into Qlik Sense
          Santosh MOTHE

          Hi Yang,

           

          Yes,you can write the SQL script in Qlik Sense while loading the Data in the Script editor (Data Load Editor).

           

          You need write the "SQL" before your sql syntax

           

          Example:

          SQL

          SELECT column_name(s)

          FROM table1

          INNER JOIN table2 ON table1.column_name = table2.column_name;

           

          Hope this helped you

           

          Thanks

           

          Regards

          Santosh M