Let’s talk Alteryx Copilot. Join the live AMA event to connect with the Alteryx team, ask questions, and hear how others are exploring what Copilot can do. Have Copilot questions?
Ask 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'
