Qliksense SQL Scripting - Error at MERGE in SQL script

QlikviewRajK — Thu, 23 Dec 2021 20:07:59 GMT

Am trying to migrate a QV application to QlikSense - both on desktop. Initially a non-select query wouldn't execute and from research we updated the package to make sure we could run non select queries... so, form what I know that's in place, unless I'm missing something else.

BTW, this and the rest of the script which has truncate, insert, update et., runs fine in its entirety in QlikView.

Thanks for any help....greatly appreciate your time.

Regards - RK

ERROR

QVX_WNEXPECTED_END_OF_DATA: ERROR[HY000] [Qlik][OracleOCI] (26) The SQL statement type (16) is not supported.: SQL MERGE INTO TBL1 K1 USING (select ColA, ColB, ColC, ColD, ColE, ColF, concat…. COLKEY from TBL1) K2 ON (K1.ColA=K1.ColA and K2.ColB=K1.ColB and K2.ColC=K1.ColC and K2.ColD=K1.ColD and K2.ColE=K1.ColE) when matched then UPDATE SET K1.COLKEY1=K2.COLKEY) !EXECUTE_NON_SELECT_QUERY.

topic Qliksense SQL Scripting - Error at MERGE in SQL script in Connectivity & Data Prep

Qliksense SQL Scripting - Error at MERGE in SQL script