Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Highlighted
wanyunyang
Contributor

Loading data from ODBC into Qlik Sense

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!

1 Solution

Accepted Solutions
srm12213
New Contributor III

Re: Loading data from ODBC into Qlik Sense

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

1 Reply
srm12213
New Contributor III

Re: Loading data from ODBC into Qlik Sense

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