Generate Rows Errors - Oh My!

[cwilcoxmtn]

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!

[JohnJPS]

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

[JoeM · Accepted solution]

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.

[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.