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 ID | Transfer Date | Name | Duplicate |
1 | 1/12/16 | A | Y |
1 | 2/04/16 | A | Y |
2 | 3/25/17 | B | Y |
2 | 4/27/17 | B | Y |
2 | 10/02/17 | B | N |
3 | 3/24/18 | C | N |
4 | 4/12/19 | D | N |
5 | 5/12/15 | E | N |
6 | 11/13/16 | F | N |
6 | 12/30/16 | F | N |
Emp ID | Transfer Date | Name |
1 | 1/12/16 | A |
2 | 3/25/17 | B |
2 | 10/02/17 | B |
3 | 3/24/18 | C |
4 | 4/12/19 | D |
5 | 5/12/15 | E |
6 | 11/13/16 | F |
6 | 12/30/16 | F |
Solved! Go to Solution.
Hi @ankitsingh2063 I mocked up a workflow that produces the output you describe.
@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?
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?