Generate Rows Errors - Oh My!

Hi All,

I have a blended datafile from about 10 sources, resulting in some data that has info to year 2020, but most data being more sparce. I want to use generate rows to create rows up to 2020. Seems simple.

I have used Summarize to add a Max_Year field and have looked at all the examples. I continue to get errors I don't understand. "Value did not change after the loop expression. Thanks for your help!

data 2.JPG

Preparation

Accepted answers

JoeM

Note that you are creating a new field. In this case, you might be looking to intialize using the max_year, but looping on your new field New_Year.

2016-02-23 23_07_41-Alteryx Designer x64 - VisitIntervals.yxmd_.png

All comments

JohnJPS

If the files are already blended, can the "Imputation" tool fill in missing values for you?

JoeM

Note that you are creating a new field. In this case, you might be looking to intialize using the max_year, but looping on your new field New_Year.

2016-02-23 23_07_41-Alteryx Designer x64 - VisitIntervals.yxmd_.png

cwilcoxmtn

Thank you John, but the empty fields shows me there are no records with that year.

cwilcoxmtn

Of course. I couldn't see the forest for the trees. Works like a dream now.

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703