Forum Discussion
remove errors rows
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"
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"check the given code.
ok thanks for your valuable suggestions
Mrk it as a solution if it fullfills your need.
thanks for your reply but the problem is
by using remove errors option actual data is also removed from the same row
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.
yuo shouldnt be using remove error.
Use replace error's option to keep the records
