Challenge #123: When will Rabbits Rule the World?

[clant]

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

[kat]

Spoiler

this took me a good while to solve! here it is with the 7 month earlier answer.



macro:

[Ruud]

Spoiler

Also bit different numbers, but same month.  

Bunnies	Human Pop	Date
784861560	336183889	2022-08-02

 

[ggruccio]

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

[benjamesdavis]

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

Thanks,
Ben

[clant]

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

[clant]

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

thanks

chris

[TylerNa]

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

[jvansistine]

This one expanded my horizons a bit with iterative macros!