Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

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

Populate Column if blank

Andyhjtran
6 - Meteoroid

Hi All, I hope you're all staying safe and well.

 

Essentially, I want it so that if column 1 is blank, it'll take the data from column 2. If the data in column 2 is blank, it'll take the data from column 3 and so forth. You can find the input and the desired output here:

Andyhjtran_0-1636077848153.png

 

Is there a way to do this without a lot of IF formulas? There's about 100 columns so it's way too much of a hassle to do it manually. I have attached a sample data set below.

 

Thank you!

 

 

 

2 REPLIES 2
Chantelb
9 - Comet

Hi @Andyhjtran 

 

You could transpose the data, filter out the null values and then use the sample tool to take the first value for each row.

 

Chantelb_0-1636078742342.png

Hope this helps!

 

Cheers,

Chantel

chukleswk
11 - Bolide

You can use something like this to bring it all to a single column:

Capture.PNG

Labels