community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

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

Adding Rows

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.

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