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 #21: Date Reformatting

gaoa
ボリード
スポイラ
gaoa_0-1676168808639.png

I used too many steps! 😂

Colintermeer
アステロイド

Answer

siddharth_28
アステロイド

Re: Challenge #21: Date Reformatting

jnpac
メテオール

Used regex and multi-row formulas to achieve final result

tmich20
アステロイド
スポイラ
Screenshot 2023-02-17 152853.png

Minsu
メテオール

Here is my solution!

I was struggling to think how to put the data horizontally...

finally I got to know that I can create record in each data and use join!

Ed2000
アステロイド
スポイラ
Ed2000_0-1676650053402.png

 

akorte1
アステロイド

Done

caltang
17 - Castor
17 - Castor

This is how I would do it:

 

スポイラ
caltang_0-1676710560218.png

 

Calvin Tang
Alteryx ACE
https://www.linkedin.com/in/calvintangkw/
ed_hayter
パルサー
スポイラ
ed_hayter_0-1676821454176.png