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
in short, I'd use this CReW macro:
https://gallery.alteryx.com/#!app/Generate-Date-Rows/5e31f42a826fd30ffcbf2c14
cheers,
mark
Thanks Mark
Beeing a newbe this seems abit heavy to understand at first glance, but I will look further into your suggestion.
BR
Dan
User | Count |
---|---|
106 | |
82 | |
70 | |
54 | |
40 |