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

Removing both, duplicate values and the initial value.

Carolyne
8 - Asteroid

How would I go about excluding the duplicates in my data set? In this case the duplicate lines are the 3 claim IDS (699,699 and 699R).  My initial data set is :

 

Customer IDClaim IDFill DateDay Supply
1232411/8/201890
1239574/16/201890
1236997/15/20180
1236997/15/201890
123699R7/15/2018-90
1234287/16/201890
12391010/1/201890

 

My output goal is:

 

Customer IDClaim IDFill DateDay Supply
1232411/8/201890
1239574/16/201890
1234287/16/201890
12391010/1/201890

 

Thanks!

2 REPLIES 2
krysten
7 - Meteor

Hi Carolyne,

 

You would want to use the Unique tool to remove the duplicates, then join the data back together to remove the initial value as well. The join tool allows you to choose what kind of join you prefer, in this case it would be the right join excluding the inner join. I have attached a sample workflow for you with the data provided so you can see what I did. 

Carolyne
8 - Asteroid

Thanks!

Labels