Last Updated: May 10, 2022
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)...]" . 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.