Create rows of data based on grouping

[bsolove123]

I have data that I summarized by State and Entity and retrieved the minimum tax period. See example below.

State       Legal Entity Name      Min_Period
CO          Entity 1                        2017
AZ           Entity 1                        2018
FL            Entity 2                       2020
CO           Entity 2                       2019

I am trying to use Alteryx to create rows, adding on different period by entity until the 2021 period is reached. See ideal outcome example below.

State    Legal Entity Name     Period
CO       Entity 1                      2017
CO       Entity 1                      2018
CO       Entity 1                       2019
CO       Entity 1                      2020
CO      Entity 1                       2021
AZ       Entity 1                      2018
AZ       Entity 1                      2019
AZ       Entity 1                      2020
AZ        Entity 1                     2021
FL Entity 2 2020
FL Entity 2 2021
CO Entity 2 2019
CO Entity 2 2020
CO Entity 2 2021

[phottovy · Accepted solution]

Hi @bsolove123 ,

You can use the generate rows tool to accomplish this. Here is how I set up the configuration:

Output:

[binuacs]

@bsolove123 One way of doing this

[nagakavyasri]