Join the Alteryx Community’s Maveryx Summer Cup event! Compete, network with others, and earn your gold through a series of challenges from July 24th to August 11th. Learn more about the event here.

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