Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
Start Free Trial

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
Top Solution Authors