Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
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
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