Let’s talk Alteryx Copilot. Join the live AMA event to connect with the Alteryx team, ask questions, and hear how others are exploring what Copilot can do. Have Copilot questions? Ask here!
Start Free Trial

Alteryx Designer Desktop Discussions

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

Update several fields within certain rows

h12
8 - Asteroid

Hi all

 

I have the following data set (Note, the original data set has over 1mil rows)

 

ABCDEFG
[Null]1[Null][Null][Null]465
[Null]2[Null][Null][Null]787
[Null]3[Null][Null][Null]89

 

I essentially want to update the [NULL] fields to 'N/A' in one go. I can update it using a formula tool but that takes some time as the main data set has 10+ columns which contain [NULLS] which I need to update.

 

Final output to look like

 

ABCDEFG
N/A1N/AN/A]N/A465
N/A2N/AN/AN/A787
N/A3N/AN/AN/A89

 

 

Many thanks

10 REPLIES 10
h12
8 - Asteroid

Thank you @Jean-Balteryx  @atcodedog05 ! Not sure how I missed that top bit!

Labels
Top Solution Authors