General Discussions
Discuss any topics that are not product-specific here.
Alteryx spatial analysis really do great job!
Part1
Just calc area for all rectangular patterns and find max. It's simple task. Offset +1 is needed.
(ABS([X]-[Source_X])+1)*(ABS([Y]-[Source_Y])+1)Overall combined polygon is needed. My approach was to create new 3 points for each coordinate so it forms square, and trace each point individually to create sequence polygon. Then we will have 4 individual sequence polygon, so combine them into one. This is overall polygon map.
Here is how it looks like with my dataset.
Next, create all rectangular patterns as spatial polygon object as well, and find rectangular that are contained within overall polygon by the Spatial Match tool.
Once you get the target rectangular, then you just have to find the one with max area.
@gawa, great explanation! This was a fun problem except for a misunderstanding that cost me a lot of time...
Hint: Graph the points to identify a pattern that is easier to search!
Spatial tool is good.
So it turns out (as we all know) where you place parentheses in an equation matters... strangely enough mistyping my area equation in part 1 didn't throw off my solution... it just became the bane of my existence in part 2 as I spent an hour plus looking in the wrong places to fix the problem.
It's been ages since I've had a good reason to use spatial tools, I really enjoyed this one!
No need for spatial in part 1, just calculate side lengths.
Part 2 builds a shape which is only green and red tiles, then builds each possible rectangle. Spatial match to determine which rectangles are entirely within red and green tiles, then calculate the area in the same way as part 1.
