community Alteryx IO Mission Control
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.

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
Polls
We’re dying to get your help in determining what the new profile picture frame should be this Halloween. Cast your vote and help us haunt the Community with the best spooky character.
Vote
Hide Results
Don’t ghost us—pick your favorite now!
Labels