Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Using two select statement in the data laod

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.

31 Replies
rahulpawarb
Specialist III
Specialist III

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

Not applicable
Author

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.