Replacing value with null not working

[Kirt1965]

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"})

[spinfuzer]

Replacer.ReplaceValue instead of Replacer.ReplaceText

[Kirt1965 · Accepted solution]

I got it to work.  I forgot that you have to use ReplaceValue instead of ReplaceText.