I try to use query in UI path. I have a short query:
“Select [Delivery Date], [PoNumber] As ‘OrderNumber’, Case When [New delivDate] Is NULL Then [Delivery Date] Else [New delivDate] End As ‘sapdate’ From [Sheet1$] Where [Purchorder no] = 85XXXXX9 order by ‘NewDate’”
I have to add that my “database” is excel and another queries work correctly.
But when I use this query I’ve got error: Execute Query: Unrecognized keyword WHEN
Somebody has any information about this error?
When I execute this same query in MS SQL I’ve got correct result but in UI Path I’ve got error.
I suppose that it can be UI Path constraint because when I tried run query in UI Path included word CONVERT I receive similar error.
Thank a lot