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

Samanthaj_hughes
ACE Emeritus
ACE Emeritus

Another great quick one, this time I challenged myself to do it in a few tools as possible. :) Managed to get it down to 3. :)

 

#Alteryxrocks
MMehdi
8 - Asteroid

Hello,

 

Challenge #2 resolved, please validate my solution (want more badges :D)

Thank you !

 

Workflow screenshot :

Spoiler
work screenshot.png

 

 

 

 

kelly_gilbert
13 - Pulsar

Parsing data - always good practice!

MJG
7 - Meteor
 
Mattpannuzzo
7 - Meteor

My complete solution.

DanielArenas
7 - Meteor
 
Nadjet
5 - Atom

Hello,

Here is my solution

RWvanLeeuwen
11 - Bolide

my solution was to parse to columns using single and double quotation marks. I added a comma in the text as the case implied it should correctly parse the text when the delimiter comma were to be used in the field value. let me know if I need to do anything to earn this badge

Oliver
6 - Meteoroid

My solution.

anthonyd
6 - Meteoroid

My solution.