Free Trial

Alteryx Designer Desktop Discussions

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

Remove repeated value only and keep remainder of data

tiverson
8 - Asteroid

tiverson_0-1636991104089.png

I have data that has similar values that have different PO #'s.  

How can I return the data so that only the value is removed and the remainder of the data stays intact?

 

Once this is done, I need to sum by project name.

tiverson_1-1636991215251.png

Thanks,

Todd

 

2 REPLIES 2
Jonathan-Sherman
15 - Aurora
15 - Aurora

Hi @tiverson,

 

You could a multi-row tool technique to identify duplicate records and remove the values.

 

JonathanSherman_0-1636992174054.png

 

I've attached my workflow for you to download if needed!

 

Kind regards,

Jonathan

 

tiverson
8 - Asteroid

0

Labels
Top Solution Authors