accessing an array element is throwing an error: Failed to parse the SQL statement

Thu, 25 Feb 2016 12:45:04 GMT

The following query in the load script succeeds when loaded on the designer tool but fails on the server with the error: Failed to parse the SQL statement (and then the following query)

select e.id as "Emp ID",

e.name as "Emp Name",

e.manager[1] as "Manager One",

e.manager[2] as "Manager Two"

from "employee" e

The employee table is as follows:

id	name	manager
1001	sarah
1002	john	[1001]
1003	bruce	[1001,1002]
1004	elton	[1001,1002]

Basically its not able to handle the array element. Please let me know how else can we access the array element of a column.

Thanks for you help!!

Re: accessing an array element is throwing an error: Failed to parse the SQL statement

Gysbert_Wassenaar — Thu, 25 Feb 2016 16:59:27 GMT

The sql statement is sent to the odbc or oledb driver you are using. It is that driver that can't handle the arrays. Qlikview has nothing to do with it. You need to find another driver or create a view or stored procedure in your sql database that returns a record set that the driver you're using is capable of handling.

topic Re: accessing an array element is throwing an error: Failed to parse the SQL statement in QlikView

accessing an array element is throwing an error: Failed to parse the SQL statement

Re: accessing an array element is throwing an error: Failed to parse the SQL statement