Forum Discussion
Solved
Replace Errors
Hi all,
if I want to set the error values in a numeric column to zero using the query editor, does the following line of code will solve the problem?
#"Replaced Errors" =Table.ReplaceErrorValues(#"Changed Type",{{"CustomerID",0}})
Hi Hashiru ,
You code should be ok.
M code for your reference.
let Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("ddFLCoNAEIThu/TahVXj8wa5w+BCUExA3CXnT0jS0kLN9qc2H5Wz3dZ5eRwbrLLXvD9X2FRlu/8qvfJb/9vkNcXaeG1ibb22sXZeu1h7r32sg9ch1tHrGCvqk1Ff+pk1D9oHDYQWQhOhjdBIaCUKTGomCy9qJjWTmknNpGZSM6mZLDDThzm9AQ==", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type text) meta [Serialized.Text = true]) in type table [RH = _t, Values = _t]), #"Changed Type" = Table.TransformColumnTypes(Source,{{"RH", type text}, {"Values", type text}}), gourp= Table.Group(#"Changed Type", {"Values"}, {{"RH", each """" & Text.Combine(List.Transform(_[NumberColumn], (x) => Number.ToText(x)), ",") & """", type text}}), #"Replaced Errors" = Table.ReplaceErrorValues(gourp, {{"RH", "0"}}) in #"Replaced Errors"
1 Reply
Hi Hashiru ,
You code should be ok.
M code for your reference.
let Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("ddFLCoNAEIThu/TahVXj8wa5w+BCUExA3CXnT0jS0kLN9qc2H5Wz3dZ5eRwbrLLXvD9X2FRlu/8qvfJb/9vkNcXaeG1ibb22sXZeu1h7r32sg9ch1tHrGCvqk1Ff+pk1D9oHDYQWQhOhjdBIaCUKTGomCy9qJjWTmknNpGZSM6mZLDDThzm9AQ==", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type text) meta [Serialized.Text = true]) in type table [RH = _t, Values = _t]), #"Changed Type" = Table.TransformColumnTypes(Source,{{"RH", type text}, {"Values", type text}}), gourp= Table.Group(#"Changed Type", {"Values"}, {{"RH", each """" & Text.Combine(List.Transform(_[NumberColumn], (x) => Number.ToText(x)), ",") & """", type text}}), #"Replaced Errors" = Table.ReplaceErrorValues(gourp, {{"RH", "0"}}) in #"Replaced Errors"