Fill in columns if included between a certain timeframe

GdeH

Hello, 

In the example below, I have as input the 3 first column, I would like to create all other columns. 

I would like to write the amount in the column of the month if the month is included between the begin date and end date, if it is not included between those date I would like to have a 0 amount. 

Would someone have any idea how I could automate this in Alteryx? 

Amount	Begin Date	End Date	Jan-19	Feb-19	Mar-19	Apr-19	May-19	Jun-19	Jul-19	Aug-19	Sep-19	Oct-19	Nov-19	Dec-19	Jan-20	Feb-20	Mar-20	Apr-20	May-20	Jun-20	Jul-20	Aug-20	Sep-20	Oct-20	Nov-20	Dec-20
5000	01/01/2019	31/12/2019	5000	5000	5000	5000	5000	5000	5000	5000	5000	5000	5000	5000	0	0	0	0	0	0	0	0	0	0	0	0
1000	01/01/2019	31/12/2020	1000	1000	1000	1000	1000	1000	1000	1000	1000	1000	1000	1000	1000	1000	1000	1000	1000	1000	1000	1000	1000	1000	1000	1000
2000	01/05/2019	31/04/2020	0	0	0	0	2000	2000	2000	2000	2000	2000	2000	2000	2000	2000	2000	2000	0	0	0	0	0	0	0	0
4000	01/04/2020	31/12/2020	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	4000	4000	4000	4000	4000	4000	4000	4000	4000

AngelosPachis

Hi @GdeH ,

You can do that by generating the intermediate dates through a generate rows tool, then assigning an ID into each month to maintain the chronological order when dates will be placed on your column headers and then cross-tabing to the format you desire.

Hope that helps, let me know if that worked for you or you have any questions on the workflow.

Regards,

Angelos

example.yxmd