Adding a flag to rows above when value found in one column

Hi All,

I have a set of data that is grouped by ticket numbers and each ticket contains various steps (some have more). I want to flag the rows that come before a specific milestone.

The defining value is Hard Schedule Date, however, within each ticket number, there isn't always a set number of steps before it. So, I want to flag all rows before hard schedule date

I've attached sample data.

Any help would be greatly appreciated!

Thanks,
Heather

sample data.xlsx

Preparation

Accepted answers

fmvizcaino

Hi @heatherreid70 ,

My bad, I shared my workflow before saving it but I'm sharing the correct one now adapted to your alteryx version alteryx.

Best,

Fernando Vizcaino

2020-06-24 Adding a flag to rows above when value found in one column.yxmd

All comments

fmvizcaino

Hi @heatherreid70 ,

You can do that by a combination of sort + multi-row tool. First I'm ordering the steps in a descending order to help multi-row tool identify the specific step you need and create a flag for all the rows before.

I'm attaching an example here.

Best,

FErnando Vizcaino

2020-06-24 Adding a flag to rows above when value found in one column.yxmd

heatherreid70

Thank you so much, unfortunately, I cannot open the workflow because I'm still using 2019.3. Would it be possible for you to either downgrade your workflow or explain to me what you need in the formula and the multirow tool?

Thanks!

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703