Let’s talk Alteryx Copilot. Join the live AMA event to connect with the Alteryx team, ask questions, and hear how others are exploring what Copilot can do. Have Copilot questions? Ask 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
GenAI Contest Form
License admin COmmunity Live
Labels
Top Solution Authors
View All