ACT NOW: The Alteryx team will be retiring support for Community account recovery and Community email-change requests Early 2026. Make sure to check your account preferences in my.alteryx.com to make sure you have filled out your security questions. Learn more here
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

ez_mich
アトム

nice

amruthas2
アステロイド

I tried to take different approach in this exercise, as this had just 3 columns it was easier to use formula trim, but i tried to use find and replce option to identify [", ' ] and replaced it with blank for whole text - as the delimiter was constant [ - ] and used datetime conversion  

jeffrey_angeles
メテオール

Challenge 2 done.

nissy_mathew
アトム

Beginner here... solved my first challenge :)

amadra
アステロイド

Hello.

Submitting my first ever weekly challenge solution.

 

Carlo_S
メテオール

Done!

RobbieA
アステロイド

My solution for Challenge #2!

 

スポイラ
RobbieA_0-1644767781069.png

 

FrederikE
パルサー

My first solution for an alteryx challenge. 

Akash__on
アステロイド
スポイラ
Akash__on_0-1644890082961.png

 

1) use text to column as , delimiter

2) use trim function in formula tool

3) Select tool and rename some column

magdziula_k
アトム

Littlle different than sugested, Used RegEx tool