The Inspire Pin contest has begun! Win a free pass to Inspire by submitting your design to be made into a real-life pin! Submission details can be found here.

community Alteryx Academy MyAlteryx
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
Start Free Trial

Alteryx Designer Desktop Discussions

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

Show rows based on two criteria

esjohnston
6 - Meteoroid
‎03-24-2021 01:44 PM

Hello, 

I have a data set that contains amount change and percentage change of two accounts over 2 years. If the amount change is greater than 200 AND 10%, I would like to see which rows meet that criteria (preferably only returning the rows that meet both thresholds). 

 

Thank you! 

Alteryx WF Desired Data.xlsx
Labels:
Reply
0 Likes

Accepted SolutionSolved! Go to Solution.

1 REPLY 1
Emil_Kos
17 - Castor
17 - Castor
‎03-24-2021 01:48 PM

Hi @esjohnston,

 

I have prepared a workflow for you:

Emil_Kos_0-1616618883905.png

The output:

 

Emil_Kos_1-1616618904338.png

 

Filter.yxmd
Reply
Community Live building your first workflow
Labels