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