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...
You should notice that the last line is full of errors. This is because the data is not parsed correctly. For example, the following code demonstrates a similar situation：
Table.ReplaceErrorValues(#table({"A", "B"}, {{1,2 }, {1}}), {{"B", 3333}})The solution to this problem should be to ensure that the data can be parsed correctly, or use Table.RemoveLastN to discard the last row.