We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
community Alteryx IO 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.

How to retain qualified rows？

phoebe_90
8 - Asteroid
‎03-24-2023 07:46 AM

sheet 1

Document NumberAccountAmount in local currencyCost Center
19000902245082101348.16 
1900090265010000-1348.16709536
190009172450821014350.17 
1900091765010000-14350.17709536
1900091765010000285.71709536

Only keep rows when the volume of "Document Number"=2

For example

Document NumberAccountAmount in local currencyCost Center
19000902245082101348.16 
1900090265010000-1348.16709536
Labels:
Reply
0 Likes
1 REPLY 1
FinnCharlton
13 - Pulsar
‎03-24-2023 07:49 AM

Hi @phoebe_90 , this workflow will do that for you:

FinnCharlton_0-1679669364134.png

 

Keep when count=2.yxmd
Reply
0 Likes
Community Live
Labels
Top Solution Authors
View All