Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!!
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.