Free Trial

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

MWiechmann
6 - Meteoroid

Done!

 

Spoiler
Screenshot 2025-01-23 114856.png

Although I have to admit I only realized after googling that StripQuotes() is a thing. Before that I tried REGEX_Replace and realized Alteryx seemingly does not support escaping quotation marks...

Screenshot 2025-01-23 114121.png

 

ThomasHoefer
6 - Meteoroid

 

Spoiler
2_Solution.png

 

 

ethanwillie
6 - Meteoroid

Looks good

reubn
6 - Meteoroid
Spoiler
2.png

jfissel
8 - Asteroid
Spoiler
challenge_2_jfissel.png
Jfoss
6 - Meteoroid

Really simple challenge but great to see a different way of solving the question

Allan3112
5 - Atom

Hello community! Please find attached the file for the solution. I am a beginner so will be continuing to post more :)

To summarise my Approach 

1. Used "Text to Columns" to break into columns. 

2. Renamed the columns 

3. Removed punctuation except for the 'Poem Read Date Column' (will be handled later)

4. Finally used a combination of DateTimeParse and dateTimeFormat to convert the value into the needed output. 

 
Dominic_Brady
7 - Meteor

My solution!

holly_jones12
7 - Meteor

A good intro to spliting columns and using dateparse

MonicaRoyal
6 - Meteoroid

 

Spoiler
Challenge#2_Solution.png

I'm learning that there  were many way to solve these challenges, here's mine 🤓