Replace Data in Separate Column

[emenendez2]

Hello,

I am setting up a WF and the input file has several columns such as Job Title, Coach, and Manager.

For the column titled "Job Position" I want the corresponding Coach and Manager column/cells to show N/A for those with the "Job Position" Director or Senior Manager.

Is there something I can add to the WF so for everyone marked as Director or Manager will show N/A in the Coach and Manager column?

Thanks!

[DataNath]

Hey @emenendez2, from the scenario you've outlined, you ought to be able to use a Multi-Field Formula, with something along the lines of the following expression:

IIF([Job Title] IN ('Director','Senior Manager'),'N/A',[_CurrentField_])

This just checks whether [Job Title] is Director or Senior Manager. If so, it changes [Coach] & [Manager] to 'N/A' (only affects these two fields as you only tick these two in the 'Select field(s)' part of the tool configuration, and if not it leaves the fields as they are:

Before:

After:

[emenendez2]

Thank you @DataNath , this worked perfectly!!

[DataNath]

No problem @emenendez2, happy to help! Feel free to mark the solution so others with the same issue can find it easily in future! If you need further help then please let us know :)