Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I've spent a while coming up with a query for an Oracle dB, but QLikview doesn't seem to accept it at all. I'm quite sure it's not T-SQL and am fairly sure I conformed to ANSI but still QV isn't having it. Attached is a test app with the load script, any suggestions would be helpful!
Hi David
In script Qlikview only interpreted commands SQL of driver.
Use:
Load * |
SQL <your_code_sql>;
<your_code_sql> must have query sql
Kind Regards!
Hi David
In script Qlikview only interpreted commands SQL of driver.
Use:
Load * |
SQL <your_code_sql>;
<your_code_sql> must have query sql
Kind Regards!
as your query isn't a trivial one, use a different tool (sqlplus, sql developer, toad, etc....) to test the query on an oracle database; when the syntax of the query is ok, add the query to QlkiView script (usually a correct query run without any problem in QlikView load script but debugging and testing the query is easier in an external and ad hoc tool)