Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I am trying to use SQL Query of existing application in my Qlik sense data load editor which will get the data from Oracle DB. It is huge query which has lot of joins and functions.
Qlik sense is not loading data until remove SQL functions like to_char. Please let me know, can we use SQL Query AS IS or we need to convert into Qlik sense compatible. Thanks in advance.
Can you post your script snippet? Can you run the same SELECT statement from another DB client?
when u load data from an sql database u'll have sthing like this:
load
col1,
col2,
...
coln
select
col1,
col2,
...
coln
from yourSource;
in the load part, u can use QLIK's FUNCTIONS; in the SELECT part, u can use the SQL Functions relative to ur database.
Hope that was clear?