Generate rows from data range

[Dan-Ketil]

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

[MarqueeCrew]

@Dan-Ketil ,

 in short, I'd use this CReW macro:

https://gallery.alteryx.com/#!app/Generate-Date-Rows/5e31f42a826fd30ffcbf2c14  

cheers,

 mark

[Dan-Ketil]

Thanks Mark

Beeing a newbe this seems abit heavy to understand at first glance, but I will look further into your suggestion.

BR

Dan

[echuong1]

You can use the generate rows to create records for the values in between. See attached.

I split everything out so it's a little easier to understand, but you can definitely consolidate some things.