Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

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

Retain duplicates

mb1824
9 - Comet

Hi, 

 

I have data on Department, stock # and profit. Some stock #s appear in multiple departments and I want to identify those & the profit attributed to each department.

 

I can use a unique tool to find the stock # with duplicates, but what is the best way to then filter the original data to show only those stock #s with profit attributed to each department

1 REPLY 1
MarqueeCrew
20 - Arcturus
20 - Arcturus
On the output anchor of duplicates, place a select and only pass the stock number field. Next connect a unique tool to output the uniquely duplicated stock numbers. Now you can join the data that was sent into the connect tool with these stock numbers. In the join, deselect the right stock numbers. The data passing through the join ancho is the data that you’re interested in.

Cheers,

Mark
Alteryx ACE & Top Community Contributor

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