SOLVED
Repeat Only Change Years
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
Hongli1216
8 - Asteroid
‎09-18-2020
04:34 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
Solved! Go to Solution.
Labels:
- Labels:
- Common Use Cases
7 REPLIES 7
cs11
8 - Asteroid
‎09-18-2020
05:57 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
‎09-18-2020
06:03 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
CS,
Thanks for your time! I want to repeat these rows but change the years from 2019, 2020, 2021....until 2040.
Holly
cs11
8 - Asteroid
‎09-18-2020
06:22 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
cs11
8 - Asteroid
‎09-18-2020
06:24 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Actually you can just use a generate rows tool to create the year list, so that would also make it one step easier to implement.
‎09-18-2020
06:28 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
cs,
I cannot download your attachment. Can you put your formula or tools here? Appreciate it!
cs11
8 - Asteroid
‎09-18-2020
06:35 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
‎09-18-2020
06:46 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
cs,
Thanks for your great help! Save me a lot time! Appreciated your patience!
Holly