How to replace #N/A cells with NA from multiple columns using one tool in the alteryx.

[anonymous008_G]

Hi There,

First of all thank you very much of Alteryx community who is helping me in Alteryx projects continuously. Can someone also please help how would replace #N/A values to NA from multiple columns at a time.  

[Qiu]

@anonymous008_G 
Try to Use Multi-Field Formula tool

[gawa · Accepted solution]

hi @anonymous008_G 

The simplest way is to use Multi Filed Formula. This tool is useful when you want to manipulate multiple columns with the same configuration.

[anonymous008_G]

Thank you both