Get Inspire insights from former attendees in our AMA discussion thread on Inspire Buzz. ACEs and other community members are on call all week to answer!
community Alteryx IO Alteryx.com
alteryx Community
Search
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Close
Free Trial

Alteryx Designer Desktop Discussions

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

Remove rows in data set based on values within fields as well as running totals

monilpatel89
5 - Atom
‎04-28-2023 01:05 PM

I have a dataset with many records and some numeric fields:

 

Pre-calculated variables: A, B, C, D

Calculated variables: E = A+C, F= D+B

 

I want to remove rows based on certain criteria. i.e

if C<10,000 AND B<20,000 AND if the new value of E (after removing the row) would be <10,000 AND if the new value of F (after removing the row) would be <20,000

 

A bit stumped on how to do this, can anyone offer any advice please?

Reply
0 Likes
1 REPLY 1
Yoshiro_Fujimori
15 - Aurora
‎04-28-2023 04:59 PM

Hi @monilpatel89 ,

 

I don't see "Running Total" in your description, but if you want to remove rows, Filter tool would be the first choice.

Yoshiro_Fujimori_0-1682726271182.png

If I miss anything, please point it out.

Filter.yxmd
Reply
get your questions about inspire answered by inspire attendees
learn more about the python upgrade coming in may 2024
Labels