https://community.databricks.com/t5/data-engineering/cast-string-to-decimal/m-p/65982#M32980 <P>Hi Kaniz,</P><P>Thank you for your response.</P><P>I',m expecting that the new column should be populated as NULL after the decimal conversion, if it has any characters as below example. But it is not happening when I use the same casting in my original file.</P> Wed, 10 Apr 2024 08:56:04 GMT _Raju 2024-04-10T08:56:04Z https://community.databricks.com/t5/data-engineering/cast-string-to-decimal/m-p/65796#M32922 <P>Hello, can anyone help me with the below error.</P><P>I'm trying to cast the string column into decimal. When I try to do that I'm getting the "<STRONG><SPAN class="">Py4JJavaError: </SPAN></STRONG><SPAN><STRONG>An error occurred while calling t.addCustomDisplayData. : java.sql.SQLException: Status of query associated with resultSet is FAILED_WITH_ERROR. Numeric value 'WVL383' is not recognized Results not generated.</STRONG>" error.</SPAN></P><P><SPAN>The dataframe and error details are attached.</SPAN></P> Mon, 08 Apr 2024 10:52:17 GMT https://community.databricks.com/t5/data-engineering/cast-string-to-decimal/m-p/65796#M32922 _Raju 2024-04-08T10:52:17Z https://community.databricks.com/t5/data-engineering/cast-string-to-decimal/m-p/65982#M32980 <P>Hi Kaniz,</P><P>Thank you for your response.</P><P>I',m expecting that the new column should be populated as NULL after the decimal conversion, if it has any characters as below example. But it is not happening when I use the same casting in my original file.</P> Wed, 10 Apr 2024 08:56:04 GMT https://community.databricks.com/t5/data-engineering/cast-string-to-decimal/m-p/65982#M32980 _Raju 2024-04-10T08:56:04Z