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

ez_mich
5 - Atom

nice

amruthas2
8 - Asteroid

I tried to take different approach in this exercise, as this had just 3 columns it was easier to use formula trim, but i tried to use find and replce option to identify [", ' ] and replaced it with blank for whole text - as the delimiter was constant [ - ] and used datetime conversion  

jeffrey_angeles
7 - Meteor

Challenge 2 done.

nissy_mathew
5 - Atom

Beginner here... solved my first challenge :)

amadra
8 - Asteroid

Hello.

Submitting my first ever weekly challenge solution.

 

Carlo_S
7 - Meteor

Done!

RobbieA
8 - Asteroid

My solution for Challenge #2!

 

Spoiler
RobbieA_0-1644767781069.png

 

FrederikE
13 - Pulsar

My first solution for an alteryx challenge. 

Akash__on
8 - Asteroid
Spoiler
Akash__on_0-1644890082961.png

 

1) use text to column as , delimiter

2) use trim function in formula tool

3) Select tool and rename some column

magdziula_k
5 - Atom

Littlle different than sugested, Used RegEx tool