We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and
join in on the fun here.
General Discussions
Discuss any topics that are not product-specific here.
My solution.
Spoiler
Workflow
I personally like my workflow in that it processed the order of "XMAS" 😀.
Formula Tools
[RowNo] =
IF [Direction] IN (1,2,3) THEN [RowNo] - 1
ELSEIF [Direction] IN (4,5) THEN [RowNo]
ELSE [RowNo] + 1
ENDIF
[ColNo] =
IF [Direction] IN (1,4,6) THEN [ColNo] - 1
ELSEIF [Direction] IN (2,7) THEN [ColNo]
ELSE [ColNo] + 1
ENDIF
I personally like my workflow in that it processed the order of "XMAS" 😀.
Formula Tools
[RowNo] =
IF [Direction] IN (1,2,3) THEN [RowNo] - 1
ELSEIF [Direction] IN (4,5) THEN [RowNo]
ELSE [RowNo] + 1
ENDIF
[ColNo] =
IF [Direction] IN (1,4,6) THEN [ColNo] - 1
ELSEIF [Direction] IN (2,7) THEN [ColNo]
ELSE [ColNo] + 1
ENDIF
That was great :D
I had to use two batch macros to solve it. I am really curious how other experts solved it. I believe it will be very inspiring :P
Spoiler
Star 1
Star 2
Star 2
Picking up a bit
Spoiler
initially I made an iterative macro with appends and then filters:
but then I realised for 4 letters it wasn't needed, so I swapped to generate rows and joins, and my run time went from ~28 seconds down to 0.9
Here's my horrible filter:
but then I realised for 4 letters it wasn't needed, so I swapped to generate rows and joins, and my run time went from ~28 seconds down to 0.9
Here's my horrible filter:
(([0_col]=[1_col] AND [1_col]=[2_col] AND [2_col]=[col])
AND (ABS([0_Row]-[1_Row])=1 AND ABS([1_Row]-[2_Row])=1 AND ABS([2_Row]-[Row])=1))
OR
(([0_Row]=[1_Row] AND [1_Row]=[2_Row] AND [2_Row]=[Row])
AND (ABS([0_col]-[1_col])=1 AND ABS([1_col]-[2_col])=1 AND ABS([2_col]-[col])=1))
OR
(([col]-[2_col]=1 AND [2_col]-[1_col]=1 AND [1_col]-[0_col]=1)
AND (([Row]-[2_Row]=1 AND [2_Row]-[1_Row]=1 AND [1_Row]-[0_Row]=1) OR ([Row]-[2_Row]=-1 AND [2_Row]-[1_Row]=-1 AND [1_Row]-[0_Row]=-1)))
OR
(([col]-[2_col]=-1 AND [2_col]-[1_col]=-1 AND [1_col]-[0_col]=-1)
AND (([Row]-[2_Row]=1 AND [2_Row]-[1_Row]=1 AND [1_Row]-[0_Row]=1) OR ([Row]-[2_Row]=-1 AND [2_Row]-[1_Row]=-1 AND [1_Row]-[0_Row]=-1)))
Phew. Finally got this one. I should have flexed my AoC muscles earlier, this one brought back all the memories. Hope you all managed to find me!!!
SAM was everywhere in that wordsearch! Was a massive distraction!
D4. More in spoiler
Spoiler
My approach was to take a given point and draw four (or three points) in each coordinate: North, South, West, East, North West, North East, South West and South East. The workflow design was meant to create those directions to more easily organize the solution, even though the workflow looks like a bunch of frayed wires.
For P2, I just did all the combo joins of diagonals where they matched on a point and the letter 'A'
For P2, I just did all the combo joins of diagonals where they matched on a point and the letter 'A'
