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

Filclarke
6 - Meteoroid

Solved

 

 

NielsCainBirkmose
6 - Meteoroid

I solved it also like you :-). Would be nice to be able to share multiple valid solutions

Samuel_To
10 - Fireball

Hi @NielsCainBirkmose ,

 

It is great to hear that. 

The most interested part of Alteryx is that we can use different Tools and methods to get the same result. 

 

Cheers,

Samuel 

AntDavis42
7 - Meteor
Spoiler
Capture.PNG

Nice challenge for my first one to do... proved to me the online training doesn't sink in as well as actually doing the work.

Have used more tools than the solution. Just shows i need to work on functions more

 

 

Kirsten_L
5 - Atom

Please find attached my solution.

Jason_G
5 - Atom
Spoiler
Used text to columns to split data, used formula function to replace ' in field 3. Used the DateTime tool to covert the date format. Used RegEx to replace ". Used select function to deselect field_1 and rename columns. 
HarrisonHolt
7 - Meteor

WC 2

kstrakova
7 - Meteor

close enough to the solution

Evlieg
5 - Atom

Here is the solution

ZaydW
7 - Meteor
Spoiler
Step 1>in the "Parse" Tab use the Text to Column tool
Step 2 >in the "Preparation" Tab use the formula tool and drag on to you workflow>in the syntax type "Replace" 
Step 3>in the "parse" tab drag and drop the DateTime tool
Step4> use the Regex tool to remove your " and replace your output with a blank
Step5> use your "Select" tool from the preparation tab and run your model

Wentzel_0-1600367768266.png