Alert: There is a planned Community maintenance outage October 16th from approximately 10 - 11 PM PST. During this time the Alteryx Community will be inaccessible. Thank you for your understanding!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Find and replace on numerous field columns

Barclaysusercds
8 - Asteroid

Hello,

 

I have 5 different column headers and within the 5 columns are rows with the name written as "(blank)". How can I replace all cells with ""(blank)" to be something else.

 

If I use the find & replace I have to specific a field.

 

If I use data cleansing it doesn't allow that, only replaces NULLs

 

Current

Barclaysusercds_0-1653479622386.png

 

I want to change it to look like 

Barclaysusercds_2-1653479700787.png

 

Thanks

 

1 REPLY 1
PhilipMannering
16 - Nebula
16 - Nebula

Try using the multifield tool,

PhilipMannering_0-1653481705485.png

 

Labels