Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hello,
in one community I found a command to change the value in one column based on another column, but it doesn't work properly. Could you advise me?
The problem is as follows:
I have an ORDER_STATUS column and a load_date column. I want to change the value in the load_date column based on the value in the ORDER_STATUS column. If the ORDER_STATUS column has the value "CLAW", I want the value "NA: CLAW" to be added to the load_date column.
The function should be correct (I indicated it in the picture), but it does not do what it should.
Can you advise please? Thank you very much.
Solved! Go to Solution.
Hi @Simon_29 ,
Change 'Replacer.ReplaceText' in your formula bar to 'Replacer.ReplaceValue'.
Pete
Proud to be a Datanaut!
FYI, the reason @BA_Pete's solution works is because Replacer.ReplaceText looks for substrings and Replacer.ReplaceValue looks at the entire contents of a cell.
Hi @Simon_29 ,
Change 'Replacer.ReplaceText' in your formula bar to 'Replacer.ReplaceValue'.
Pete
Proud to be a Datanaut!
I appreciate your advice. Everything is already working. Thank you very much
FYI, the reason @BA_Pete's solution works is because Replacer.ReplaceText looks for substrings and Replacer.ReplaceValue looks at the entire contents of a cell.