Pardon our dust - Alteryx Academy is under construction. Lessons and courses completed on Community from now until January 20th will not be recorded.
Start 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

aeday
Asteroid

My Solution

mara_plc
Meteor

Done!

Hi, here's my solution.

 

Spoiler
Spoiler02_FlowScreenshot.jpg

monik
Meteor

bonsoir, mon premier exercice, merci bcp!

JessicaEP
Asteroid

Completed!

Shubhanker
Meteor

done

erica_sch
Asteroid
Spoiler
SPOILER
zaldiz
Meteoroid

Completed

Shivraj96
Meteor

Here's my answer file, drop me a reply in case of any queries.

Input:

Vsrivastava_0-1758130198327.png


Output:

 

Vsrivastava_1-1758130198328.png

 



Workflow:

Vsrivastava_2-1758130198330.png

 

Steps followed:
1.) Input tool to get raw data
2.) Parsing tool to extract different delimiters data in columns
3.) Select tool to choose right columns for output
4.) Type conversion tool to convert string to date and join required columns horizontally using multi join tool
5.) Browse tool to get final output