Hi,
Thanks for your help in advance! Please see the attached file. How to repeat the range of (row 2-row 8), just change the years in Alteryx, like from 2019 to 2040? Appreciate your time!
Holly
there is actually an easier way, which is just to use the Append Fields tool to create the Cartesian Product between the rows 2-8 and the year list, per the attached. No macro is required. See if the attached is what you are looking for.
Hi, if you always want to select specific rows 2-8 then you can use the Select Rows tool, per the attached, and then a Union to add this to your data after changing the date. But this approach is not dynamic based on any criteria in the data, only statically copying over rows 2-8
CS,
Thanks for your time! I want to repeat these rows but change the years from 2019, 2020, 2021....until 2040.
