Find Replace

[mestra28]

Hi Everyone,

I extract some data from my Oracle server and whenever there is a field that does not exist, the extract comes out as "#missing". Now I could go in to every file in excel and use the find and replace on there to transform all "#missing" into zeros. However, I wanted to see if there is a way for alteryx to do this for me? I tried to use the Find Replace tool, but did not have any luck. 

[DataNath]

Hey @mestra28, if I'm interpreting your question right then you can handle this with a Multi-Field Formula. This does what it says on the tin and allows you to apply a Formula to multiple fields at once. There's also built in functionality to change the data type upon output as well so you can change these fields into numeric, as the '#missing' will be forcing them into strings:

Before:

After:

Hope this helps!