community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Community v19.9

The latest release includes several enhancements designed to improve your Community experience!

Learn More
SOLVED

Dynamically Creating Fields (Months) per Interation 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

 

 

Alteryx
Alteryx

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. 

Digan
Alteryx

Capture.JPG,

 

 

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

 

 

 

 

 

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

Capture.PNG

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!!!~!

Labels