Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.
Free Trial

General Discussions

Discuss any topics that are not product-specific here.

Advent of Code 2020 - BaseA Style (Day 4)

Jean-Balteryx
16 - Nebula
16 - Nebula

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

18 REPLIES 18
Greg_Murray
12 - Quasar

This was a fun one! Nothing like a little regex in the evening. 

Spoiler
Greg_Murray_0-1607061065975.png

 

jdunkerley79
ACE Emeritus
ACE Emeritus

Love the smell of RegEx in the morning...

Spoiler
jdunkerley79_0-1607062640884.png


Decided to go for pure Regex validation - no tonumber-ings

jdunkerley79_1-1607062664873.png

 

AkimasaKajitani
17 - Castor
17 - Castor

My solution at Day04.

 

Using simple ToNumber function(Off course using RegEx_Match).

 

Spoiler
AkimasaKajitani_0-1607063776502.png

 

As anonymous user #1105310

Jean-Balteryx
16 - Nebula
16 - Nebula

Day 4 solution. Not that much Regex but one big filter for part 2 !

 

Spoiler
2020-12-04 08_33_51-Alteryx Designer x64 - AOC_2020_Day_4.yxmd.png
cgoodman3
14 - Magnetar
14 - Magnetar

Day 4 - Tried to do it with no regex, but used a regexcount matches as I didn't write out a really long 

substring([Field_1],2,1) IN ("0","1","2"..."a","b","c"...) for validating the hair colour.

 

Also the many filters helped finding the typo much easier than trying to next it to bring the overall tool count down.

 

Spoiler
cgoodman3_0-1607073633025.png

 

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

Managed to get the right answers but it's clear i need to brush up on my regex syntax 😀

 

It's really great looking through how different people solve things! 

danilang
19 - Altair
19 - Altair

Regex is definitely the way to go here.  Kudo's to @cgoodman3 for trying to solve it without using the regex hammer.  

 

Spoiler
danilang_1-1607088404698.png

 


 

Dan

NedHarding
7 - Meteor

Day 4 was interesting and very well suited to Alteryx.  Actually probably easier in Alteryx than in a normal programming language.

 

If anyone wants my solutions, I put them here:  https://github.com/NedHarding/Advent2020

 

 

Aguisande
15 - Aurora
15 - Aurora

My Day 4..

Going in "basic user" mode... 

Spoiler
aguisande_1-1607093731373.png

 

 

BTW... I'd love to see those Regex Expressions you (all) used later... 

Labels
Top Solution Authors