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

Weekly Challenges

Solve the challenge, share your solution and summit the ranks of our Community!

Also available in | Français | Português | Español | 日本語
IDEAS WANTED

Want to get involved? We're always looking for ideas and content for Weekly Challenges.

SUBMIT YOUR IDEA

Challenge #411: Link a New CRM to an Existing Financial System

ed_hayter
12 - Quasar

Not quite perfect - but tried to replicate the data structure in the hint box:

 

Spoiler
image.png

 

JORGE4900
8 - Asteroid

Here is my approach to it. I started by finding 10 different patterns to the communication protocol and removed them; then I removed anything after a question mark, forward slash, and semi-colon. The result was all the company names.

 

Take a peak at the workflow of Output Task 1

Spoiler
Output Task 1.png
Rob-Silk
8 - Asteroid

Solution attached below - took a while to get the initial RegEx right, and definitely helped to follow the hint on URL structure

 

Spoiler
challenge_411_RS_screencap.PNG
gerda
8 - Asteroid
Spoiler
Screenshot 2024-02-22 170851.png

This was a lot harder than expected. I thought I got the regex correct and then the answers wouldn't match and had to restart a few times. Good practice though!

DataCruncher4
7 - Meteor

Challenge 411 Solution

DaisukeTsuchiya
13 - Pulsar
Spoiler
スクリーンショット 2024-03-05 173510.png
asultanov
8 - Asteroid

A real challenge!

Spoiler
I had some discrepancies from the provided answers, but I also found some errors in the given solution.
Task 1 Errors:
Spoiler
Screenshot 2024-03-13 171550.png
Task 5 Errors:
Screenshot 2024-03-13 171559.png

Screenshot 2024-03-13 171530.png
synergy825
8 - Asteroid
Spoiler
Challenge #411 Screenshot.JPG
OzlemSigbeku
8 - Asteroid
Spoiler
411_1.png411_2.png411_3.png411_5.png

I got different answers but I did what was asked so I guess that counts?

 

fesrimo
8 - Asteroid

The Weekly Challenge are very intereting, I was solving multiple of them and this took me around 16 hours to complete them from 410 to 418.

My solutions for challenge Weekly #411