General Discussions
Discuss any topics that are not product-specific here.
I guess my teachers were right and we did need to remember y = mx + b. A great opportunity to use the generate rows tool!
Challenge 1:
Step 2: Fitler for just horizontal and vertical
Step 3: Generate X positions
Step 4: Generate Y Positions
Step 4: Group by X,Ys of generated positions and count
Step 5: Filter for any > 1
Challenge 2:
Step 2: Calculate m and b
Step 3: Generate X positions
Step 4: Calculate y using y = mx + b
Step 4: Group by X,Ys of generated positions and count
Step 5: Filter for any > 1'
Again another day where the part two wasn't that much more difficult than the first part. I just got stuck down a rabbit hole as the first attempt at building it out I had forgotten that there could be diagonals in both directions, so it's not just as case of generating the x.y co-ordinates as you need to factor in increasing and decreasing values in x and y and because I was using a join based on position instead of calculating the order needed to get my ordering correct. So while most of the time it is beneficial being able to use assumed sort in Alteryx if you are relying on a particular order you can't! So that resulted in the second part taking much longer than the first!
I use only one Generate Row tool to make diagonal line. It is a pretty forceful way. But it took long time to make the condition expression.
GitHub
