This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
It's not going to win any awards for beauty, but it got across the finish line.
Iterative Macro
Nice to be back in a comfortable Alteryx area...
with an inner macro to do the allocaion:
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!
Day16!
Today's workflow is far from elegant.
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.