Loading data from ODBC into Qlik Sense

[wanyunyang]

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!

[srm12213 · Accepted solution]

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