Record/Row removal under certain conditions
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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 👍
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Thanks both, very much appreciated and helps my learning of Alteryx a lot 👍
