Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
ALTER.NEXT:

Join us on Dec 2 for a half-day virtual analytics + data science event!
US & CA customers only

SAVE YOUR SPOT
It's the most wonderful time of the year - Santalytics 2020 is here! This year, Santa's workshop needs the help of the Alteryx Community to help get back on track, so head over to the Group Hub for all the info to get started!

Adding Rows

Highlighted
8 - Asteroid

I have data for five years with the years in different rows and corresponding data in the fields to the right of the years.

 

2018

2019

2020

2021

2022

  

I want to create rows for 2023 through 2045 that are equal to the same value as 2022.

Highlighted
12 - Quasar

@bcrisman Not a difficult ask, although this depends on the amount of extra fields you have present in your data. One option is outlined below.

 

Using a generate rows tool gets you the years, and then a multi-row formula tool would populate upcoming years. If you have a large number of fields this can be taxing as the multi-row formula tool is one field at a time.

small amount of fields.PNG

 

 

if you have a large number of them, then there's an alternative.

 

large number of fields.PNG

Labels