Challenge #470: Build the Tallest Tower

[JBevan89]

Firstly, my version of Alteryx Designer (2024.1 non-admin) does not let me save as a packages (yxzp).  So I attach the file and macro separately.  Any Ideas why it will not let me save as a package?

Spoiler

 

Spoiler

 

When I used AI to ask how to set the number of iterations to 100 for an iterative macro, it said about using a 'control parameter' tool.  But from further digging and also realising, this made it a 'batch' macro.  So from further looking into, I realised that with an iterative macro you can set the number of iterations from the interface designer as per my image above.  However, i find this quite interesting, because given the final output is 12,000 records plus, I sense that it has iterated more than 100 times.  I do not think it effects the result.  Any thoughts?

[Noah-Waite]

Added in some logic to identify the blocks included within the tower: 

Spoiler

[alineruizcampos]

Spoiler

[martinson]

Max height 42 with blocks PEGJKNR

[thomasduong]

Here is my solution to Challenge #470

Spoiler

[alexnajm]

Still don't like iterative macros 😬

[ntakeda]

Fun challenge!

Spoiler

  

[DaisukeTsuchiya]

Spoiler

I wonder why 100 itteration is required. Itteration can be finished in 6 times.

[RWvanLeeuwen]

I have found a maximum height of 73 with NNNEEEEEEEP (top to bottom block order)
@AYXAcademy-> would you kindly fact check my 73 as highest tower?

Here's my take

Spoiler

have I been p*wned or did I find a solution with mentioning?the hard part was figuring out that I should add each new block underneath, because this makes the cumulative weight much much easier to calculate

[Ryan-Yeung]

Spoiler

=========OUTPUT=========

Regex to match duplicate blocks (repeated character anywhere in string) ".*(.+)(.*\1).*"

@martinson You haven't accounted for the new load capacity of the blocks you're adding (you're only updating the load capacity of the block at the bottom of your towers), eg. in your "PEGJKNR" example, block G has a load capacity of only 1, so the J block is all you can add from the PEG state as the G block cannot load any more than that

@RWvanLeeuwen I think the provided solution assumes using each block only once (which I also didn't account for initially as it's not technically stated as such in the question lol). In the case of you can use each block as many times as you wish I get the same result (PEEEEEEENNN w/ Height 73, bottom to top)