Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.

Weekly Challenges

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

Also available in | Français | Português | Español | 日本語
IDEAS WANTED

Want to get involved? We're always looking for ideas and content for Weekly Challenges.

SUBMIT YOUR IDEA

Challenge #246: Rectangle Tangle

AYXAcademy
Alteryx
Alteryx
A solution to last week's challenge can be found hererectangles.png
 
This week you are given 4 centroids which you can turn into a rectangle. Once you have created your rectangle, find the midpoints of the lines that connect those centroids, then make another rectangle from those points. Keep doing this until the area of the rectangle is less than 5 square miles.
Aaron_Harter
11 - Bolide

I designed an iterative macro to solve this challenge:

Spoiler
246.0.PNG

246.macro.PNG
Jonathan-Sherman
15 - Aurora
15 - Aurora

Challenge 246 is done!

 

Workflow:

Spoiler
Jonathan-Sherman_0-1607954847432.png

 

Iterative Macro:

Spoiler
Jonathan-Sherman_0-1607955358795.png

 


 

 

AkimasaKajitani
17 - Castor
17 - Castor

My solution.

 

Spoiler

Workflow:
AkimasaKajitani_1-1607955209202.png
Iterative Macro:
AkimasaKajitani_0-1607955195268.png

 

Kenda
16 - Nebula
16 - Nebula
Spoiler
An iterative macro made the most sense to me here (in vertical, of course)

Kenda_0-1607956314676.png

Kenda_1-1607956345974.png

 

 

dsmdavid
11 - Bolide

Also iterative

Spoiler
dsmdavid_0-1607956350455.png
dsmdavid_1-1607956460730.png

 

dsmdavid_2-1607956483769.pngdsmdavid_3-1607956611648.png

 

 

 

RolandSchubert
16 - Nebula
16 - Nebula

My solution - used an iterative macro

 

Spoiler
246.png
PhilipMannering
16 - Nebula
16 - Nebula

First time doing a spatial calc in the multirow,

Spoiler
MacroMacro

Challenge 246 - Snip.png
phottovy
13 - Pulsar
13 - Pulsar

So many rectangles:

 

Spoiler
246.PNG

246_Macro.PNG
Greg_Murray
12 - Quasar

This was a fun one. I took an iterative approach, outputting all of the iterations and only keep the last one. 

 

Workflow

Spoiler
Greg_Murray_0-1607973240433.png



Iterative macro

Spoiler
Greg_Murray_1-1607973351076.png

 

Bonus Rectangles! 

Spoiler
Greg_Murray_2-1607973465882.png