We are updating the requirements for Community registration. As of 7/21/21 all users will be required to register a phone number with their My Alteryx accounts. If you have already registered, you will be prompted on your next login to add your phone number.

General Discussions

Discuss a wide range of topics! Questions about the Alteryx Platform should be directed to the appropriate Product discussion forum.

Advent of Code 2020 - BaseA Style (Day 5)

Jean-Balteryx
15 - Aurora

Discussion thread for day 5 of the Advent of Code : https://adventofcode.com/2020/day/5

19 REPLIES 19
NicoleJohnson
14 - Magnetar
14 - Magnetar

This AoC challenge had Alteryx written ALL OVER IT. 

 

Spoiler
Can't say I've ever used BintoInt formula before... But OH what a joy it was to have it in the arsenal for this challenge! 

Day5.JPG

Cheers!

NJ

https://github.com/AlteryxNJ/AdventOfCode_2020

jdunkerley79
16 - Nebula
16 - Nebula

Very similar to @NicoleJohnson 

 

Spoiler
day5..jd.jpg

BINTOINT all the way...

 

 

AkimasaKajitani
14 - Magnetar

My solution at Day 5.

 

My approach is different from other's.

 

Spoiler
AkimasaKajitani_0-1607148098130.png


Part 2 was simple, but I didn't know what it meant at first.

cgoodman3
12 - Quasar
12 - Quasar

Brute force following the logic of each step. So keen to understand the much shorter solution to this that others have posted!

 

Spoiler
cgoodman3_0-1607159887283.png


P.S. Just saw @NicoleJohnson and @jdunkerley79  convert to binary, and realised I completely missed this hint in the question🙄

 

Chris
Check out my collaboration with fellow ACE Joshua Burkhow at AlterTricks.com
NedHarding
7 - Meteor

There are 10 kinds of people in the world - those who understand binary and those who don't...  😉

 

Too easy.

 

Spoiler
NedHarding_0-1607167399773.png

 

patrick_digan
16 - Nebula
16 - Nebula
Spoiler
For part 2 I just sorted and found the difference instead of joining. 
patrick_digan_0-1607168377250.png

 

danilang
18 - Pollux
18 - Pollux

h.png

 

Spoiler

Replace+BintoInt 
w.png

 

 Dan

Galouzis
7 - Meteor

Exact same solution as @NicoleJohnson 😉

 

Spoiler
Galouzis_0-1607171746638.png

 

Jean-Balteryx
15 - Aurora

1st solution I came up with aka "why make it simple when you can make it really complicated" :

 

Spoiler
Capture d’écran 2020-12-05 à 16.45.47.png

Then used my brain and came up with same solution as many people :

 

Spoiler
Capture d’écran 2020-12-05 à 16.47.53.png