General Discussions
Discuss a wide range of topics! Questions about the Alteryx Platform should be directed to the appropriate Product discussion forum.
It's not going to win any awards for beauty, but it got across the finish line.
Iterative Macro
This was a good one, a little bit needle in a haystack finding the matches but it was satisfying when I worked out the approach to pairing of rules and ticket parts. And yes its nice to be back in Base A!
Macro:
Day16!
Today's workflow is far from elegant.
Possible Column Position Calculator Macro :
Outer Macro: Grouping by each Field Name
Inner Macro: Join Field is overwrited by Control Parameter.
Search Correct Field macro: Find count 1 Field.
AS anonymous user #1105310
Ran out of steam on Sunday so am missing a few days, trying not to look at the threads in detail but it looks like I missed some trickier ones!
Anyway nice to be back involved, here's my tidied up solution with an iterative macro to whittle down the field name/column numbers.
Macro-free solution (with annotations) below. Runs in 2 seconds but certainly a lot of tools.......!
This was much better than yesterday's 😅
My solutions so far: https://github.com/dsmdavid/AdventCode2020
Very messy but gets the job done. It made sense when I was building it, but I used way too many tools.
