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

matt_un
7 - Meteor

Was interesting to try and make this compatible with an unknown number of columns on input.

Spoiler
matt_un_0-1595181555024.png

 

Rekj
5 - Atom

2 challenges in as many days.

Spoiler
With a larger data set, I may have opted for checking more conditions and/or leveraging Regex patterns to catch any edge cases. 
MAT_A
7 - Meteor

Used replace formula for both double and single quotes. 

Date Parse formula and Trim are interesting didn't think of that right away.

Spoiler
MAT_A_0-1595193313150.png

 

dhmalik
5 - Atom

Hi Everyone

I'm just getting started with Alteryx.
Attempted the challenge 2.

Sean303
7 - Meteor

Fun challenge using the Text to Column, Data Cleansing, DateTime, and Select Tools...….  

CharlesZ
7 - Meteor

CharlesZ_0-1595295126413.png

 

navdude3
6 - Meteoroid

 

 

nbandla
7 - Meteor
Spoiler
nbandla_0-1595425975088.png

 

bwegrowski
6 - Meteoroid

Here is my solution. 

ranga98
7 - Meteor

Challenge 2 solution.