In my data load editor in QLIK SENSE, I wrote the SQL like
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!
try without "
ex. WHERE sio.Order Originated =1
Incorrect syntax near the keyword 'Order'.
May be try by replacing the double quotes around Order Originiated....
WHERE "sio.Order Originated" = 1
Invalid column name 'sio.Order Originated'.
You use sio as an alias for one of the tables?
I made a typo! It works now. Thanks!
Retrieving data ...