Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi, I'm connected to an SQL Database, doing some data cleaning (translations), and I'm not sure why the Replace Value is not responding. Am I missing something? Screenshot below:
Thank you,
Ovidiu
Solved! Go to Solution.
Hi @OvidiuNeacsu ,
Try changing the M code in the formula bar from 'Replacer.ReplaceText' to 'Replacer.ReplaceValue'.
If this doesn't work, then you can just add a new custom column using the same logic from your replace code.
Pete
Proud to be a Datanaut!
Yes, the Replacer.ReplaceValue did it. Thank you!
Is ReplaceValue a standard for any format?
I normally use the Replace Values menu to get the formula set up and then I add the conditions... but it always says Replacer.ReplaceText
I'm not 100% sure on the mechanics behind to be honest but, at first glance, ReplaceText should theoretically have worked as you were only dealing with pure text values (not integer, boolean, special etc.). The only thing I can think it might be is that the cells you were trying to replace started as nulls and therefore not text, but wouldn't stake my house on this.
As a general rule of thumb with replacing values, if one doesn't work, the other will 🙂
Pete
Proud to be a Datanaut!
Hi @OvidiuNeacsu ,
Try changing the M code in the formula bar from 'Replacer.ReplaceText' to 'Replacer.ReplaceValue'.
If this doesn't work, then you can just add a new custom column using the same logic from your replace code.
Pete
Proud to be a Datanaut!