Solved: error in data load editor - Qlik Community - 59768

Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.

Skip to main content

Qlik.com | Qlik Services | Qlik Help

Ask a Question

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!

1 Solution

Accepted Solutions

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

View solution in original post

6 Replies

try without "

ex. WHERE sio.Order Originated =1

The Power of shining a light on the dark side of your data.
Follow me on my LinkedIn | Know Gamma Informatica at gammainformatica.it

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

Author

Incorrect syntax near the keyword 'Order'.

Author

Invalid column name 'sio.Order Originated'.

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

Author

I made a typo! It works now. Thanks!