Challenge #240: Every Vote Counts!

[Jonathan-Sherman]

Thanks @RodLight, I do love that tip. Count records returns a row with a value of 0 whilst a summarise would return no records or rows. It's such a useful technique!

[rmassambane]

=D

[AryCardoso]

Cool!

[Maskell_Rascal]

Fun Challenge! While an iterative macro would ideally be the best solution, I ultimately decided to use a more basic test/repeat model with some fail safes built in to output the winner and stop data streaming when found. 

Solution:

Spoiler

[Tony_Castillo]

Matched the output

Spoiler

[jasperlch]

Spoiler

[Ruud]

Just here to claim to the be the first who came up with a solution.

[Spalders]

I get the correct result but if anyone can see why my iterative macro does not exit on the condition %vote > 50 I would love to know why.

Spoiler

[Tej_Singh]

Nice challenge. Simple workflow created without any macros. Will try with macros as well once later on. 

[patrick_digan]

For fun, I solved it dynamically without any macros. I used @jdunkerley79 's Alteryx Abacus formula add ins. They are super powerful when combined with Generate Rows tools.

Spoiler