Skip to content
+1-888-319-3663

COMMUNITY FORUM

Error in Calculation column 'ACCOUNT NUMBER' : End of statement expected.

Daryle asked 4 years ago
I am getting the following error on running a map I created for a sql view.  The server does have a dash (Azure-DB) and I saw the article about creating the ODBC connection with the name not having the dash.  Still get this error.  I’m on smartconnect version 20.14.0.22.  
Error in Calculation column ‘ACCOUNT NUMBER’ : End of statement expected.
Error in Calculation column ‘ITEM DESCRIPTION’ : End of statement expected.
Error in Calculation column ‘ACCOUNT NUMBER’ : End of statement expected.
Error in Calculation column ‘ITEM DESCRIPTION’ : End of statement expected.
Answers
Ethan Sorenson Staff answered 4 years ago
Daryle,
From the information you supplied all I know is that you have two calculated columns that failed. We would need to see the scripts you are running in those to lock down the cause. We would be able to provide better assistance with your specific error if you email your scripts to support@eonesolutions.com.
Ethan
Daryle replied 4 years ago

I was able to figure it out with the help of my partner. Apparently, Smart Connect did not like the space in the field name even though I had it brackets on the query. Once we put an “as AccountNumber” in the query, it worked fine. Seems like the Validate and Preview would fail, but they did not, only when I ran the map.


If you would like to submit an answer or comment, please sign in to the eOne portal.