Record/Row removal under certain conditions

[BadgerThompson]

Hi folks,

Alteryx noob here!

I have a dataset of orders, where I want to remove all orders that have lines containing the block code 'Multiple Line', but also any subsequent lines the for the same orders, where there are other block codes used, as long as those other block coded lines have the same block date as the line with the 'Multiple Line' block code. So, for example, if the order number is the same over more than one row, and that order contains a row where the block code is 'Multiple Line', I want to remove that row and any other rows for that order where the block code date is the same as the row with the 'Multiple Line' block code. Sorry if that's as clear as mud! I've tried to indicate which lines I'd expect to be removed on the sample below:

 

Thanks in advance for any suggestions 👍

[DavidSkaife]

Hi @BadgerThompson 

You could try this approach, i've annotated the tools so you know what's going on:

Also attached is the workflow, hope it helps!

[john_watkins]

Always good to see different ways to do this.  This one with a few flags and a multiline tool.

[BadgerThompson]

Thanks both, very much appreciated and helps my learning of Alteryx a lot 👍