We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
Start Free Trial

Alteryx Designer Desktop Discussions

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

Fill nulls across rows using data in row +1 without using 15 million multi row tools.

hellyars
13 - Pulsar

I want to fill the nulls across multiple fields using the data found in row+1 without using 12 or more multi-row formulas.  Is this possible. Below is an example of how the data appears with the Null values not filled.

 

Note:  The rows will share LN, Level of Detail and Value to start.

 

YearLNAcctAcct TitleBikeLevel of DetailValue
2020999[Null][Null][Null]Comment100
20209999001CerveloS-3Line100
2020999[Null][Null][Null]Comment35456
20209998003SpecializedRoubaix ProLine35456
8 REPLIES 8
PhilipMannering
16 - Nebula
16 - Nebula

Hey @hellyars 

 

Something like this?

 

PhilipMannering_0-1605231486036.png

 

hellyars
13 - Pulsar

Thank you.  I am slowly learning that RecordID can be your best friend.

PhilipMannering
16 - Nebula
16 - Nebula

Definitely.

 

And transposing > doing something > crosstabbing back is a common scenario when you want to do the same thing across multiple columns (and can't use the Multifield).

Qiu
21 - Polaris
21 - Polaris

@hellyars 
No chance to do the field test

1113-hellyars.PNG

hellyars
13 - Pulsar

@Qiu Cool.  Check out the solution above.  It simple and elegant using Transpose + MultiRow+ CrossTab.

Qiu
21 - Polaris
21 - Polaris

@hellyars 
My understanding was to avoid using MultiRow due to huge data.

hellyars
13 - Pulsar

@Qiu  I was being dramatic when I said "15 million multi row tools".  I was trying to avoid using 10 or more multi tool rows. 

Qiu
21 - Polaris
21 - Polaris

@hellyars 
haha, guess I am being too serious.

Anyway, good your problem gets solved.

Labels
Top Solution Authors