Formula to Generate New Columns

Question

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 IDStartWk1 Wk2Wk3Wk4Wk......Wk10001DateStart+(7 daysStart + 14daysStart+21daysstart+28daysetcetc2Date

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!

data.csv

BrandonB · Accepted Answer

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