remove errors rows

[Anonymous]

How to remove error rows without losing original data 

[Anonymous · Accepted solution]

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"

[Anonymous]

check the given code.

[Anonymous]

ok thanks for your valuable suggestions

[Anonymous]

Mrk it as a solution if it fullfills your need.

[Anonymous]

thanks for your reply but the problem is 

by using  remove errors option actual data is also removed from the same row 

[Anonymous]

yuo shouldnt be using remove error.

Use replace error's option to keep the records 

[Vijay_A_Verma]

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.

[Vijay_A_Verma]

Go to Home menu - Remove Rows - Remove Errors

[Anonymous]

hi vijay ,

thanks for your reply but the problem is 

by using  remove errors option actual data is also removed from the same row