Forum Discussion
Cannot replace error with null
Hi community, Apologies for what might seem like a basic question, but I am facing an issue converting text entries to null values in my dataset. While I’ve reviewed multiple examples online, I s...
Hi kobkabnaja ,
Based on your description that the conversion of errors to nulls is not performed as expected, you can try using the following code to create a new column to perform the conversion
= try Number.FromText([YourColumnName]) otherwise null
Best regards,
Albert He
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly