Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.
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