Hi
I am a newbie in Alteryx
I have a table looking like
| Customerid | datestart | datestop |
| 1 | 2021-01-01 | |
| 2 | 2020-01-01 | 2023-12-31 |
| 3 | 2020-06-01 | 2021-06-30 |
| 4 | 2021-02-01 | 2024-12-31 |
Now I need to two things.
1: where ever datestop is not se, I will sett it to end of current year + 5. So for customerid 1 datestop be set to 2026-12-31, that I know how to do
2: i need to create a table looking like
| Customerid | period |
| 1 | 2021-01 |
| 1 | 2021-02 |
| 1 | 2021-03 |
| 1 | 2021-.. |
| 1 | 2021-12 |
| 1 | 2022-01 |
| 1 | 2022-.... |
How do I solve this?
BR
Dan
