Forum Discussion
remove errors rows
How to remove error rows without losing original data
Hello Anonymous , what do you mean by remove error rows without losing original data?
You want the error values to be replaced with null then
you can do something like this
let Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45W8nNUitWJVvLNz0jMA7MMDQyUYmMB", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [Name = _t]), #"Changed Type" = Table.TransformColumnTypes(Source,{{"Name", Int64.Type}}), #"Replaced Errors" = Table.ReplaceErrorValues(#"Changed Type", {{"Name", null}}) in #"Replaced Errors"
9 Replies
Hello Anonymous , what do you mean by remove error rows without losing original data?
You want the error values to be replaced with null then
you can do something like this
let Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45W8nNUitWJVvLNz0jMA7MMDQyUYmMB", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [Name = _t]), #"Changed Type" = Table.TransformColumnTypes(Source,{{"Name", Int64.Type}}), #"Replaced Errors" = Table.ReplaceErrorValues(#"Changed Type", {{"Name", null}}) in #"Replaced Errors"Select all columns of the table. To do this, you can press CTRL+A
Transform menu - Replace values - Replace errors - put null
This will replace only error values with null and will not touch any other data in your rows.
Go to Home menu - Remove Rows - Remove Errors
