topic Re: Problems with scripting SQL query in Qlik in QlikView

Problems with scripting SQL query in Qlik

Wed, 25 Nov 2015 17:00:10 GMT

Hello,

Originally I had written the below basic query in an Access db and was connecting through ODBC.

However, since this is now set up to automatically generate daily on a trigger, I need to get the script into Qlik.

Could someone please offer advice on what I may be doing incorrectly as I keep getting syntax errors.

Thank you!

Karen

LogEventData:

Load *;

SELECT pat."CASE_CONFIRMATION_NUM"

, cnc."PATIENT_ID"

, cnc."CNC_TYPE"

, cnc."CHOICE_TEXT"

FROM SISI."CNC_COMMENT" cnc

INNER JOIN

SISI."MFV_PAT_SCHEDULING" pat

ON (cnc."PATIENT_ID" = pat."PATIENT_ID")

WHERE cnc."CNC_TYPE" = 'Flip Room Case'

cnc."CHOICE_TEXT"='Yes';

Re: Problems with scripting SQL query in Qlik

simospa — Wed, 25 Nov 2015 17:21:18 GMT

Hi,

remove the quotes.

SELECT pat.CASE_CONFIRMATION_NUM

, cnc.PATIENT_ID

, cnc.CNC_TYPE

, cnc.CHOICE_TEXT

FROM SISI.CNC_COMMENT cnc

INNER JOIN

SISI.MFV_PAT_SCHEDULING pat

ON (cnc.PATIENT_ID = pat.PATIENT_ID)

WHERE cnc.CNC_TYPE = 'Flip Room Case'

cnc.CHOICE_TEXT='Yes';

Re: Problems with scripting SQL query in Qlik

t_chetirbok — Wed, 25 Nov 2015 17:38:26 GMT

Hi!

Maybe if you'll add "sql" on the front "select ..", it will be ok.

Re: Problems with scripting SQL query in Qlik

Mon, 30 Nov 2015 14:39:53 GMT

Sorry for a late reply...Simone and Tatsiana, I tried both your suggestions and unfortunately, neither made a difference (still getting an error).

Thank you

Re: Problems with scripting SQL query in Qlik

simospa — Mon, 30 Nov 2015 17:13:48 GMT

Enable log (Settings --> Document Properties --> General --> Generate Logfile

and - after reloading - paste here the trace with error so we could understand better.

Re: Problems with scripting SQL query in Qlik

t_chetirbok — Mon, 28 Dec 2015 12:28:42 GMT

if the issue is not resolved, then post logfile, please

Re: Problems with scripting SQL query in Qlik

Mon, 28 Dec 2015 12:32:02 GMT

There was a securities issue with the ODBC that the admin was able to resolve; thank you all for your help!