Formula to Generate New Columns

[fitzviz]

I am starting with the attached data where I have a unique ID and a start date.

I would like to create a formula that creates for each unique ID, 1000 new columns called Wk1, Wk2, Wk3...... Wk1000.

Subject ID	Start	Wk1	Wk2	Wk3	Wk4	Wk......	Wk1000
1	Date	Start+(7 days	Start + 14days	Start+21days	start+28days	etc	etc
2	Date

Wk1 is equal to Start Date +7 days, Wk2 = Start Date + 14 days etc until Wk1000 = Start Date + (7*1000) days

Does anyone have a recommendation on the best way to do this in Alteryx?

Thanks in Advance!

[bbak91 · Accepted solution]

Generate Rows, then a couple of formulas, and finally a crosstab should do the trick! Picture below and workflow is attached. 

 

[bbak91]

If you also need the "Subject ID" or "Record ID", you can go to the crosstab tool and also check it in the group by section.