Filling in field blank/empty/Null values

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?

Help

Accepted answers

KarolinaRoza

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

All comments

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-Other-Value/m-p/752027/highlight/true#M180584

KarolinaRoza

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

Quick Links

This months top contributors

mceleavey 383

mbarone 337

Hollingsworth 335

LanisC 335

AdamR 335