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 Duplicates based on Datetimediff

ankitsingh2063
8 - Asteroid

Hello community,

 

I have an input data (as shown in first table) - the problem is that the duplicate Employees (with same Emp ID) have more than 1 different Transfer dates. I want an output data (as shown in second table) such that it would have only one of the cases wherein the Transfer dates are at least 45 days or less apart.

 

Emp IDTransfer DateNameDuplicate
11/12/16AY
12/04/16AY
23/25/17BY
24/27/17BY
210/02/17BN
33/24/18CN
44/12/19DN
55/12/15EN
611/13/16FN
612/30/16FN

 

Emp IDTransfer DateName
11/12/16A
23/25/17B
210/02/17B
33/24/18C
44/12/19D
55/12/15E
611/13/16F
612/30/16F
3 REPLIES 3
JosephSerpis
17 - Castor
17 - Castor

Hi @ankitsingh2063 I mocked up a workflow that produces the output you describe.DatetimeDiff.JPG

ankitsingh2063
8 - Asteroid

@JosephSerpis Thanks for a quick turnaround.

 

While this was just a mocked up data, I have cases wherein the difference between Row-1: Date and Row:Date is between 0 and 45 - how do I get those cases?

JosephSerpis
17 - Castor
17 - Castor

Hi @ankitsingh2063 that workflow should catch anything that between 0 and 45 days. Just tested the workflow for an example where it 0 days and it was filter out in the workflow via the T output in the filter have included the workflow. Could you provide some data or some more info if the example is not working exactly how you want?

Labels