In case you missed the announcement: Alteryx One is here, and so is the Spring Release! Learn more about these new and exciting releases here!

Alteryx Designer Desktop Discussions

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

Fill down Latest Non-Null Value in a Column

hemant86
11 - Bolide

Hi All,

I have data in below format -

hemant86_0-1678985167633.png

I need to fill down latest non-null value. So the expected output is below

hemant86_1-1678985342942.png

I am able to achieve this using Multi-Row tool but it works only for 1 Field at a time and I have more than 30 fields to fill. Any way to use Multi-Field tool and achieve the same.

 

 

14 REPLIES 14
hemant86
11 - Bolide

@DataNath The workflow that you shared works for the sample data I shared earlier. Even in case of of Columns having all Null values. Problem is with this dataset that i just shared

DataNath
17 - Castor
17 - Castor

@hemant86 understood. Are you able to check this over? I think the groupings should work but hard to tell without a more extensive dataset.

 

DataNath_0-1679047360235.png

hemant86
11 - Bolide

Hi @DataNath Can you please try the attached file. This very close to what my data set looks like. The above flow works fine for a single column but fails for multiple columns.

DataNath
17 - Castor
17 - Castor

@hemant86 most recent iteration:

 

DataNath_0-1679058160592.png

hemant86
11 - Bolide

Thanks a tone @DataNath This did the job for me.😊

Labels
Top Solution Authors