Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I am trying to query same database but different tables using SQL language with two SELECT statement from the data load editor but it keeps giving me error. But my query separately when tested on my SQL developer?? Does qlik sense not allow using more than one Table.
Hello Victor,
After the primary analysis of the shared application, I could see that table INCIDENT_MANAGEMENT is loaded into Qlik. I believe that you have problem with first SQL Statement. In this statement you are retrieving data from VOC_FEEDBACK_V2_VIEW view. Please check the credentials used in Qlik Sense are same as you are used while running these SQL in IDE. If these are different then their might be access related issue. Also assign logical table names to each SQL Statement and try reloading.
Thank you!
Rahul
Hi Raul,
Thanks for replying. I have resolved it, the editor for some reason did not want me to use SELECT *, I had to specify the fields I needed.