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

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Upgrade Alteryx Designer in 10 Steps

Debating whether or not to upgrade to the latest version of Alteryx Designer?

LEARN MORE

Adding Rows

Alteryx Partner

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.

Bolide

@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