Fill Category Up & Down Based on Other Value

I need help (as usual). I need to fill the null values with a category ([Air District]) between Totals. This is a fill 1-N nulls up to the last row before Total (excluding Total) and fill 1-N nulls down to (and including) Total . I almost had it using a few Multi-Row tools, but I got stuck.

Simple workflow attached.

Screen Shot 2021-04-27 at 11.34.01 AM.png

Fill Category based on Value of Another Field.yxzp

Help

Expression

Accepted answers

Luke_C

Hi @hellyars

Take a look at this, I think it is accomplishing what you need. To explain:

Multi-row to fill down unless preceding row is a total row
Record ID tool & sort to reverse the order of the data
Multi-row formula to fill down remaining nulls (this is really filling 'up')
Sort to put data back into original order

Fill Category based on Value of Another Field.yxmd

All comments

Luke_C

Hi @hellyars

Take a look at this, I think it is accomplishing what you need. To explain:

Multi-row to fill down unless preceding row is a total row
Record ID tool & sort to reverse the order of the data
Multi-row formula to fill down remaining nulls (this is really filling 'up')
Sort to put data back into original order

Fill Category based on Value of Another Field.yxmd

hellyars

@Luke_C I knew I was missing something. I forgot the RecordID flip technique. Thanks.

apathetichell

Didn't see @Luke_C 's post due to lag - and here's a different approach - use "on-road" as id. - filter out - where you have the fill value - join back based upon id. Just realized that "on-road" isn't always the first entry. Same process would work for "Total" but obviously use the solution that actually works for your problem.

on-road fixed.yxmd

KarolinaRoza

Hi @hellyars ,

I hope my workflow helps you.

Regards,

Karolina

Fill Category based on Value of Another Field.yxmd

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703