Dynamically Creating Fields (Months) per Interation Question

[AnnArborThom]

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

[DiganP]

Can you please clarify your question? Are you trying to create multiple fields based on months. Ex: You want to have July, August, September as field names if you are choosing a start date as July and End date as September?

The reason you are getting the same field over and over is because you only have a starting date. When it runs the iteration a second time, it already sees the column name because the month is not changing. It needs another date to act as a stopping date. 

[AnnArborThom · Accepted solution]

,

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 solution]

@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 solution]

Patrick Thank!!!~!