community Alteryx IO Mission Control
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
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