Challenge #470: Build the Tallest Tower

[Pilsner]

Great challenge!

Spoiler

 

 

[Hub119]

Solution attached.

Spoiler

Workflow

Spoiler

Tower Macro

[olga_strubbe]

Thank you so much, Kosuke, @KosukeUchihashi 

This was a great challenge and helped me to practice building iterative macros.

Spoiler

Macro: 

[olga_strubbe]

I forgot to mention that in solving this challenge I followed in footsteps of @RolandSchubert 

Though, even then, I had trouble with schema.  I find schema not very "stable" or rather reliable in Alteryx environment, as macros and tools that  use it have to be exact to the tee, so if one has a string of 1 or a byte field, it will not match another respective string or numeric field.  It gets very complex with large data sets and biz partners updating their input and subsequent schema changes, that I find Dynamic Input, macros and other tools that use schema, fail in these circumstances.  I hope Alteryx can one day tackle this issue.  Thank you. 

[AaronSmatta]

I need to brush up on my iterative macros...

[Yoshiro_Fujimori]

It took time to figure out how to reduce the explosion of the number of iterating rows...

But it was fun!

Spoiler

Main Workflow

Iterative Macro

Formula Tool
[BlockID] = [BlockID] + [New_BlockID]
[Weight] = [Weight] + [New_Weight]
[LoadCapacity] = Min([LoadCapacity] - [New_Weight], [New_LoadCapacity])
[Height] = [Height] + [New_Height]

[Yash9889]

Fun Challenge, took more time than expected

 

 

[Bobbyt23]

Took me a while as I was trying to work out all the different combinations of block order, then realised the order was static. Great challenge.

Spoiler

[AkimasaKajitani]

My solution. This is like AoC.

Spoiler

[ggruccio]

I failed several times yesterday - had to think about what was going wrong...and came back with an idea this morning to fix my macro!

Spoiler

Main workflow 


and macro -