Qliksense SQL Scripting - Error at MERGE in SQL script
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.
