Hi All
I have used the Alteryx help section on Date Time to understand how to add months to a date but am having difficulty applying it.
Here is my data set:
| Tile Seq | Mat | Tile | Date | Total | Right_Date | | Right_Date |
1 | ABC1 | 2 | 2018-01-01 | 4 | 2018-03-01 | | 2018-03-01 |
| 1 | ABC1 | 2 | 2018-02-01 | 6 | 2018-03-01 | | 2018-04-01 |
| 1 | ABC1 | 2 | 2018-03-01 | 8 | 2018-03-01 | | 2018-05-01 |
| 1 | ABC1 | 2 | 2018-04-01 | 10 | 2018-03-01 | | 2018-06-01 |
| 2 | DEF2 | 2 | 2018-01-01 | 1 | 2018-02-01 | | 2018-02-01 |
| 2 | DEF2 | 2 | 2018-02-01 | 2 | 2018-02-01 | | 2018-03-01 |
| 2 | DEF2 | 2 | 2018-03-01 | 4 | 2018-02-01 | | 2018-04-01 |
| 2 | DEF2 | 2 | 2018-04-01 | 8 | 2018-02-01 | | 2018-05-01 |
The first 'Right_Date' column is what I already have, and the second is what I want to achieve.
Based on either the change in Tile Seq N# or MAT number I want to add a month from the first date in the right date column and continue down until we reach the next Tile Seq or MAT number.
Another one that I am sure is easy but I just can't get to function.
Thanks
