Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

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