Dynamically Creating Fields (Months) per Interation Question

Question

I am struggling to dynamically create a field per month of analysis via an iteration macro.

It appears that the append field tool will only recreate the same field over and over (see attached)

Ideally I would like to be able to do a month over month analysis with a variable set of months.

Any suggestions will be greatly appreciated

MonthCalc.yxmc

AnnArborThom · Accepted Answer

,

Dagan,

Thanks for taking the time to help me,

I try change the month in the formula tool but it does not appear to work,

See snapshot above

patrick_digan · Accepted Answer

@AnnArborThom Good talking to you on the phone! I agree with you that you were on the right track. I've attached what I quickly created to create a new column per iteration.

Note that I also had to change the macro's properties in the interface designer to auto configure by position. Then it outputs a column for each number starting at 0 and ending at my hardcoded 15.

Hope that helps!

AnnArborThom · Accepted Answer

Patrick Thank!!!~!