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

[heatherreid70]

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

[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

[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!

[chinu267]

open the YXMD file in Notepad++ and then change the version to whatever is your's and save.

After saving open as usual and it should work

<?xml version="1.0"?>
<AlteryxDocument yxmdVer="2019.4">

In above example you should change 2019.4 to 2019.3 and save the XML file that was open in Notepad

[heatherreid70]

Hi there,

So I tried that and it worked!  However, it's still showing only one tool, so I'm assuming that it wasn't saved after it was created. 😞

[fmvizcaino · Accepted solution]

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

[chinu267]

Yes there is only one tool. Follow instructions in the previous reply he has given and u should be able to replicate what is there

[heatherreid70]

This is perfect!  thank you so much!