producing column of days having start_date and end_date

[jeanilieski]

Hi everyone.
I have a table with campaigns’ start_date and end_date columns.  Start_date may repeat(!) 
I want to produce another table where all the days of particular campaign (between start_date and end_date) will be displayed per unique day (!) of the year. Is this possible?
I provided an excel file where I show my current position and my desired output.
Thank you for your answer!

p.s. it is not important if the name of the campaign will be displayed, it can be also dummy output (1/0)

[CarlDi · Accepted solution]

Hi there! To generate the days between start_date and end_date you would use the Generate rows tool. I also added a formula tool plus a cross-tab to somewhat replicate your desired output2 tab. See attached for details.

Hope that helps!

-Carl

[jeanilieski]

Perfect CarlDi! That's exactly what I needed, short and clear!

[jeanilieski]

Thank you a lot!

[CarlDi]

@jeanilieski no problem! if you could mark my response as a solution it would be greatly appreciated. happy alteryx'ing