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 4)

Alteryx Certified Partner

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

12 - Quasar

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

Spoiler
Greg_Murray_0-1607061065975.png

 

16 - Nebula
16 - Nebula

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

 

Alteryx Certified Partner

My solution at Day04.

 

Using simple ToNumber function(Off course using RegEx_Match).

 

Spoiler
AkimasaKajitani_0-1607063776502.png

 

As anonymous user #1105310

Alteryx Certified Partner

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
12 - Quasar
12 - Quasar

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

 

Check out my collaboration with fellow ACE Joshua Burkhow at AlterTricks.com
6 - Meteoroid

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! 

17 - Castor
17 - Castor

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

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

 

 

Alteryx Certified Partner
Alteryx Certified Partner

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...