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.
community Alteryx IO MyAlteryx
alteryx Community
Search
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Close
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

MatteoReddavide
8 - Asteroid
‎07-18-2023 08:15 AM

My solution

 

Spoiler
Screenshot 2023-07-18 171429.png
challenge_21_start_file.yxmd
Reply
0 Likes
lwolfie
11 - Bolide
‎07-19-2023 08:08 AM

I took a different approach with a couple more tools.

challenge_21_solution_LW.yxmd
Reply
0 Likes
GabrielaTudor
8 - Asteroid
‎07-20-2023 08:50 AM
Spoiler
challenge 21.jpg
challenge_21_G.yxmd
Reply
0 Likes
AndreeaS
8 - Asteroid
‎07-20-2023 10:51 PM
Spoiler
21.png

 

challenge_21_done.yxzp
Reply
0 Likes
H_a_n_g_C_h_e_n__x3
8 - Asteroid
‎07-23-2023 09:40 PM

I think I may have used 1 too many tools 

challenge_21_Complete 7-24.yxmd
Reply
0 Likes
Dani_Lin
8 - Asteroid
‎07-25-2023 07:44 AM

solved

challenge_21_DML_Solution.yxmd
Reply
0 Likes
wbaliwag
6 - Meteoroid
‎08-01-2023 06:44 PM

alteryx challenge.PNG

Challenge 35 Data Cleansing Practice - WBALIWAG.yxmd
Reply
0 Likes
rickytung
6 - Meteoroid
‎08-02-2023 05:13 AM

.

challenge_21_Date Reformat_RT.yxmd
Reply
0 Likes
trazeen
6 - Meteoroid
‎08-02-2023 09:21 PM

My solution

challenge_21_TR_solution.yxmd
Reply
0 Likes
clm_lamb
6 - Meteoroid
‎08-04-2023 01:24 AM

An alternative solution to multi-row formula, using record id to identify years and month number.

 

 

challenge_21_solution.yxmd
Reply
0 Likes
Live Weekly Challenge