Weekly Challenge

Solve the challenge, share your solution and summit the ranks of our Community!
IDEAS WANTED

We're actively looking for ideas on how to improve Weekly Challenges and would love to hear what you think!

Submit Feedback
We've recently made an accessibility improvement to the community and therefore posts without any content are no longer allowed. Please use the spoiler feature or add a short message in the message body in order to submit your weekly challenge.

Challenge #123: When will Rabbits Rule the World?

Highlighted
8 - Asteroid

This was a fun one. I still havent worked out how to make the macro stop so if anyone can help me with that id appreciate it!

 

Thanks

 

Chris

Highlighted
12 - Quasar
Spoiler
this took me a good while to solve! here it is with the 7 month earlier answer.

Challenge #123 final.PNG

macro:

Challenge #123 iteration.PNG
Highlighted
Alteryx Certified Partner

 

Spoiler
Also bit different numbers, but same month.  

BunniesHuman PopDate
7848615603361838892022-08-02

 Capture.PNG

 

Highlighted
12 - Quasar
12 - Quasar

Hi @clant,

 

You'll need to structure your workflow so the iteration macro output comes after the filter (i.e. only send it back thru the loop until the criteria is met).  I've just given you a simple snapshot from your workflow to show how the logic should work.  Given that you've summarized the data prior to the filter you may need to reconstruct the dataset downstream before sending it back through  Hope this helps!

 

Spoiler
iteration.JPG
Highlighted
6 - Meteoroid

What version was this made in? I can't open the file with 11.0.3.

Thanks,
Ben

Highlighted
8 - Asteroid

Thank you @ggruccio that makes sense! I just have to append the summariesed data back to it then do the filter.

Highlighted
8 - Asteroid

Hi @benjamesdavis, I did this in 2018.2 sorry, i just upgraded mine the other day.

 

thanks

 

chris

Highlighted
9 - Comet

First iterative macro and I certainly learned a ton. Hope to use these more often in my daily work.

Bunny.jpg

Highlighted
Alteryx Partner

This one expanded my horizons a bit with iterative macros!

12 - Quasar