Generate Rows on Single Date Column and Repeat Based on Another Column Value

[GokcinWalch]

I have a data set in alteryx designer as table 1 below and would like to generate rows looks like to turn it into the table in table 2.  I appreciate the help!

Table 1:

Table 2:

[Gaurav_Dhama_]

Take the difference between the min date and the max date, use the generate rows tool to generate new rows with this difference as the parameter.

now you have lets say 20 rows of data. Add append tool and append the min date to it.

Now using formula tool, use dateadd function, to add days as per the recordid.

Join on the dates from original date and new dates.

Union all data, use multi row to get the remaining data to rows.

[flying008 · Accepted solution]

Hi, @GokcinWalch 

FYI.

Input				Output
Item	Start	ItemDate		Item	Start	ItemDate
8	N	5/31/2025		8	N	05/31/2025
8	P	6/3/2025		8	N	06/01/2025
8	A	6/12/2025		8	N	06/02/2025
8	C	6/19/2025		8	P	06/03/2025
8	P	6/22/2025		8	P	06/04/2025
8	A	6/25/2025		8	P	06/05/2025
				8	P	06/06/2025
				8	P	06/07/2025
				8	P	06/08/2025
				8	P	06/09/2025
				8	P	06/10/2025
				8	P	06/11/2025
				8	A	06/12/2025
				8	A	06/13/2025
				8	A	06/14/2025
				8	A	06/15/2025
				8	A	06/16/2025
				8	A	06/17/2025
				8	A	06/18/2025
				8	C	06/19/2025
				8	C	06/20/2025
				8	C	06/21/2025
				8	P	06/22/2025
				8	P	06/23/2025
				8	P	06/24/2025
				8	A	06/25/2025

[GokcinWalch]

This will work!! THANK YOU!!

[GokcinWalch]

Never mind I got it and worked beautifully.  Thanks again!