Filling in field blank/empty/Null values

[HomesickSurfer]

Hi

As does Excel, when filling-down values in a Column, I can replicate such in Designer using a formula expression within a Multi-Row tool (2 rows).

Adversely, when attempting to fill-up in Designer, there is no such option, other than for a single row.

My work-around is to assign a RecordID to the rows, sort descending, apply the formula, then resort ascending.

Does anyone have any alternate solutions other than this?

[Luke_C]

Hi @HomesickSurfer That's the best way that I've seen it done. I'll be following this thread to see if others have other ideas. Power Query has 'fill-up' functionality, so I'd imagine Alteryx could have an easier way to do it.

[HomesickSurfer]

Hi @Luke_C 

I have found a different approach that appears to work.

@KarolinaRoza has posted a probable solution!

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Fill-Category-Up-amp-Down-Based-on-Oth...

[KarolinaRoza · Accepted solution]

Hi @HomesickSurfer 

I hope my previous post was helpful for you, if you need any help feel free to post your sample data. 

Regards,

Karolina