Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi,
I'm wondering where I'm going wrong with this formula. The goal is to replace the null values in "Description.2.2" with the values in "Description.1". I'm getting no errors with this formula, but it doesn't do anything at all. I've tried putting "null" in quotes, as well as without. It makes no difference.
What am I missing here?
= Table.ReplaceValue(#"Added Prefix","null", each _[Description.2.2],Replacer.ReplaceText,{"Description.1"})
Solved! Go to Solution.
Hi @barf
use the following queries
let Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WMlTSUTIyVorViVZKBDLBDGMYowzIKCpRio0FAA==", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type text) meta [Serialized.Text = true]) in type table [Description.1 = _t, Description.2.2 = _t]), #"Changed Type" = Table.TransformColumnTypes(Source,{{"Description.1", type text}, {"Description.2.2", type text}}), #"Replaced Value" = Table.ReplaceValue(#"Changed Type","",each _[Description.1],Replacer.ReplaceValue,{"Description.2.2"}) in #"Replaced Value"
Create a new conditional column and populate values from both columns based on condition.
= Table.AddColumn(#"Changed Type", "Description 3", each if [Description 2] = null then [Description 1] else [Description 2])
Hi @barf
use the following queries
let Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WMlTSUTIyVorViVZKBDLBDGMYowzIKCpRio0FAA==", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type text) meta [Serialized.Text = true]) in type table [Description.1 = _t, Description.2.2 = _t]), #"Changed Type" = Table.TransformColumnTypes(Source,{{"Description.1", type text}, {"Description.2.2", type text}}), #"Replaced Value" = Table.ReplaceValue(#"Changed Type","",each _[Description.1],Replacer.ReplaceValue,{"Description.2.2"}) in #"Replaced Value"
Easiest just to make a new column using similar conditional logic, rather than amending an existing one