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
7 - Meteor

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
1 REPLY 1
FinnCharlton
13 - Pulsar

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

FinnCharlton_0-1679669364134.png

 

Labels