Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
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

michael_apau
8 - Asteroid

Screenshot 2023-03-13 093033.png

Antoinette
5 - Atom

Challenge 2 image.png

katestrohm
6 - Meteoroid

1. Text to columns

2. StripQuotes formula to remove quotes in columns 1 and 3

3. DateTime tool to convert string data to a date

4. Select tool to rename and remove columns

katestrohm_1-1678804226703.png

 

mindyzhang99
8 - Asteroid

My Solution

1) Use the Delimiters of , " ' to split the Field_1 column to 7 columns

2) Use the DateTime to convert string into date

3) Select the columns you need and rename them

mindyzhang99_1-1678957691128.png

 

 

asimmonz9076
7 - Meteor

Done.

aniselyasi
5 - Atom

aniselyasi_0-1679068984776.png

 

Abie
6 - Meteoroid

Done

sylwia-rej
7 - Meteor

My solution:

Spoiler
sylwiarej_0-1679252168916.png

 

yuval
6 - Meteoroid

my solution 

silvia_srb
5 - Atom

My solution