Forum Discussion
Solved
Replacing value with null not working
Hello all,
I am trying to do a conditional replace to null and it is not working. Under a specific circumstance an employee ID and his/her supervisor's ID will be the same. In that situation, I want to set the supervisor ID to null. My code is below, but it doesn't work. The only time I can get replacing to null to work is if I enter null directly into the Replace values... dialog box from the context menu right clicking on the column name. I need it to work dynamically as below.
Table.ReplaceValue(#"Filtered rows", each [SUPERVISOR_ID], each if [SUPERVISOR_ID] = [EMPLID] then null else [SUPERVISOR_ID], Replacer.ReplaceText, {"SUPERVISOR_ID"})
I got it to work. I forgot that you have to use ReplaceValue instead of ReplaceText.
