Hi,
I have a combined list of employee with date. The list is cumulative; At the end of month I have a 4 week cumulative total but the "Date" Field is being overwritten to the latest report date.
What I need is be able to overwrite the "date" field to reflect the accurate week of the employee's record for trending purpose. Is there a good solution using Alteryx? Thanks.
see below for example:
| | | | | Ideal Output | | |
| Employee ID | Movement Type | Date | | Employee ID | Movement Type | Date |
| Bob | Hire | 1/4/2019 | | Bob | Hire | 1/4/2019 |
| Sara | Loss | 1/4/2019 | | Sara | Loss | 1/4/2019 |
| Frank | Hire | 1/4/2019 | | Frank | Hire | 1/4/2019 |
| Bob | Hire | 1/11/2019 | | Kevin | Hire | 1/11/2019 |
| Sara | Loss | 1/11/2019 | | Dave | Loss | 1/11/2019 |
| Frank | Hire | 1/11/2019 | | Amy | Loss | 1/11/2019 |
| Kevin | Hire | 1/11/2019 | | Casey | Loss | 1/18/2019 |
| Dave | Loss | 1/11/2019 | | Louis | Loss | 1/18/2019 |
| Amy | Loss | 1/11/2019 | | Carl | Loss | 1/18/2019 |
| Bob | Hire | 1/18/2019 | | Robert | Hire | 1/25/2019 |
| Sara | Loss | 1/18/2019 | | Will | Hire | 1/25/2019 |
| Frank | Hire | 1/18/2019 | | Denise | Hire | 1/25/2019 |
| Kevin | Hire | 1/18/2019 | | | | |
| Dave | Loss | 1/18/2019 | | | | |
| Amy | Loss | 1/18/2019 | | | | |
| Casey | Loss | 1/18/2019 | | | | |
| Louis | Loss | 1/18/2019 | | | | |
| Carl | Loss | 1/18/2019 | | | | |
| Bob | Hire | 1/25/2019 | | | | |
| Sara | Loss | 1/25/2019 | | | | |
| Frank | Hire | 1/25/2019 | | | | |
| Kevin | Hire | 1/25/2019 | | | | |
| Dave | Loss | 1/25/2019 | | | | |
| Amy | Loss | 1/25/2019 | | | | |
| Casey | Loss | 1/25/2019 | | | | |
| Louis | Loss | 1/25/2019 | | | | |
| Carl | Loss | 1/25/2019 | | | | |
| Robert | Hire | 1/25/2019 | | | | |
| Will | Hire | 1/25/2019 | | | | |
| Denise | Hire | 1/25/2019 | | | | |
