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
Solved! Go to Solution.
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 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!
Patrick Thank!!!~!