We've recently made an accessibility improvement to the community and therefore posts without any content are no longer allowed. Please use the spoiler feature or add a short message in the message body in order to submit your weekly challenge.
6/17/21: We have completed maintenance for the Search functionality on the Community. If you are seeing any issues, please try to clear your cache first. If the issue persists please email Community@alteryx.com

Weekly Challenge

Solve the challenge, share your solution and summit the ranks of our Community!

Also available in | Français | Português | Español | 日本語
IDEAS WANTED

We're actively looking for ideas on how to improve Weekly Challenges and would love to hear what you think!

Submit Feedback

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.