Search

Dataset

Last Updated: Oct 19, 2021

Articles

I am trying to convert a column of OrderAmount to integer. For that, I am removing the Rupees symbol. I am trying to use the Substring function of SQL schema editor, but getting the error as "Alias field must contain characters [(a-z), (A-Z), (0-9)...]" . Image description

This error occurs while editing the schema in SQL Dataset, there are column names with a 'space' or '-' or inline tables. Remove Inline tables and remove 'spaces' or '-', if any in the column names while editing the schema. Make sure you do not use special characters, such as $,-,_, etc. for Alias.

Did you find what you were looking for?