error in data load editor

[wanyunyang]

Hi guys,

In my data load editor in QLIK SENSE, I wrote the SQL like

SELECT...

FROM...

WHERE sio."Order Originated"=1

The error message is: The multi-part identifier "sio.Order Originated" could not be bound

Can anybody help me? Thanks!

[agigliotti]

try without "

ex. WHERE sio.Order Originated =1

[sunny_talwar · Accepted solution]

May be try by replacing the double quotes around Order Originiated....

In my data load editor in QLIK SENSE, I wrote the SQL like

SELECT...

FROM...

WHERE "sio.Order Originated" = 1

[wanyunyang]

Incorrect syntax near the keyword 'Order'.

[wanyunyang]

Invalid column name 'sio.Order Originated'.

[sunny_talwar]

You use sio as an alias for one of the tables?

[wanyunyang]

I made a typo! It works now. Thanks!