In case you missed the announcement: The Alteryx One Fall Release is here! Learn more about the new features and capabilities here
ACT NOW: The Alteryx team will be retiring support for Community account recovery and Community email-change requests after December 31, 2025. Set up your security questions now so you can recover your account anytime, just log out and back in to get started. Learn more here
Start Free Trial

General Discussions

Discuss any topics that are not product-specific here.

Advent of Code 2021 Day 2 (BaseA Style) - Dive!

jdunkerley79
ACE Emeritus
ACE Emeritus

Discussion thread for day 2 of the Advent of Code - https://adventofcode.com/2021/day/2

26 REPLIES 26
joshbennett
11 - Bolide
11 - Bolide

Day 2 with Summarize and Multi-Row Formula

 

Spoiler
joshbennett_0-1638862581838.png

 

SeanAdams
17 - Castor
17 - Castor

OK - so this one was a bit wierd - why can't they separate aiming and driving.    Don't let these people on a motorbike!

 

Spoiler
Part 1:  Just summarised the directions - then cross-tabbed them and added them together.

SeanAdams_0-1639008556848.png

Part 2:

Given that the Aim drives Distance and depth - started with a multi-row for aim; then another multi-row for depth, then the distance.

SeanAdams_1-1639008651254.png

 

 

SeanAdams
17 - Castor
17 - Castor

Just to be clear @cgoodman and   @NicoleJohnson - what is the official tool count to quality for "Tool Golf" and is it unique tools or unique types of tools?

cgoodman
ACE Emeritus
ACE Emeritus

Unique tools I think is how I see it (so minimise tool id tags in the xml).

Chris
Check out my collaboration with fellow ACE Joshua Burkhow at AlterTricks.com
dsmdavid
11 - Bolide
Spoiler
dsmdavid_0-1639089534952.png

 

Mchappell67
9 - Comet
Spoiler
Mchappell67_0-1639369316942.png

 

caitlynmcintyre
9 - Comet

Loved this one because it was mostly just math

Spoiler
caitlynmcintyre_0-1639625822693.png

 

Labels
Top Solution Authors