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 #2: Preparing Delimited Data

lanidinh
7 - Meteor

Done

CurtisPaterson
8 - Asteroid

Challenge 2.png

Erinashlee2
6 - Meteoroid
Completed
 

Challenge2Completed.PNG

 

pavan2023
5 - Atom

My Soln

Spoiler
image.png
avbade
6 - Meteoroid

My Solution

pmag
8 - Asteroid
Spoiler
image.png

 

dinazulaikha18
8 - Asteroid

My answer >.<

roopmathi
7 - Meteor
Spoiler
Here is my approach 
> Used formula tool to clean up and parse upstream
1. I removed " and ' using REPLACE () in the formula tool
2. I converted the date string from 16-JUN-01 to YYYY-MM-DD using replace and regexp_replace
I used Chat-GPT to help me with the syntax for both. I wouldn't know how to write this myself without looking at the documentation
> Then used the Text to Columns tool to split by delimiter,
formulas used.png

 

Challenge#2 soln by RG.png

 




JasperMB
8 - Asteroid
Spoiler
Challenge #2_JB.png

ArunjotSingh
5 - Atom

My solution to challenge 2