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

removign duplicates based on date #

Faisalomran1
7 - Meteor

here is the input that I have

Job Start Datewell API Numbernumber of fracturing job opearations on the wellTotal Base Water Volume (gallon)
1/9/20181107200500001231710
3/13/20181107200500001259678
12/18/20141107203940000293326
2/18/20151107203940000293238
1/16/20151107204000000296432
2/22/20161107204000000242000
5/29/20151107204150000247124
2/8/20161107204150000250000
4/12/2013302310675000028555904
4/15/2013302310675000028737134

what i am trying to output is this

Job Start Datewell API Numbernumber of fracturing job opearations on the wellTotal Base Water Volume (gallon)   
3/13/20181107200500001259678   
2/18/20151107203940000293238   
2/22/20161107204000000242000   
2/22/20161107204000000242000   
4/15/2013302310675000028737134   

in order to do this I need the software to include ( well API number) that appears in the second date and exclude the first appearance.

thank you.

 

 

 

4 REPLIES 4
bpatel
Alteryx
Alteryx

hi @Faisalomran1 ,

 

Is this what you are looking for?

 

bpatel_0-1601054546736.png

hope this helps

Faisalomran1
7 - Meteor

that is helpful. thank you

 

I just have one problem some ( well api numbers) appears three times and I want to include only the second appearance. how can i do this.

bpatel
Alteryx
Alteryx

hi @Faisalomran1 ,

 

Sure. Here is one approach that will always pick the second instance.

 

bpatel_0-1601055522309.png

 

Faisalomran1
7 - Meteor
3/2/201640305660800003
3/28/201640305660800003
4/4/201640305660800003

thank you so much, I just have another question.

 

so in the table above how cam I add a column to report the number of appearance as shown below

3/2/2016403056608000031
3/28/2016403056608000032
4/4/2016403056608000033

 

Labels