In case you missed the announcement: Alteryx One is here, and so is the Spring Release! Learn more about these new and exciting releases here!

Alteryx Designer Desktop Discussions

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

Deleting similar values

tiverson
8 - Asteroid

How can I look at a list of data, decide if it has a PO assigned , then removes all of the duplicated amounts?

 

tiverson_2-1637171019843.png

 

1 REPLY 1
MarqueeCrew
20 - Arcturus
20 - Arcturus

@tiverson ,

 

This is scary, but I'd just use a UNIQUE tool and check the Amt field.  It will select the "FIRST" amount that is unique and go from there.

 

Cheers,

 

Mark

Alteryx ACE & Top Community Contributor

Chaos reigns within. Repent, reflect and restart. Order shall return.
Please Subscribe to my youTube channel.
Labels
Top Solution Authors