Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Record/Row removal under certain conditions

BadgerThompson
5 - Atom

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:

 

 Sample 123.png

Thanks in advance for any suggestions 👍

3 REPLIES 3
DavidSkaife
14 - Magnetar

Hi @BadgerThompson 

 

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

 

Capture.PNG

 

Also attached is the workflow, hope it helps!

john_watkins
11 - Bolide

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

alteryx-community-multiline sample-screenshot.yxmd.jpg

BadgerThompson
5 - Atom

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

Labels
Top Solution Authors