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

gaoa
11 - Bolide
‎02-11-2023 06:28 PM
Spoiler
gaoa_0-1676168808639.png

I used too many steps! 😂

challenge_21_start_file_gaoa.yxmd
Reply
0 Likes
Colintermeer
8 - Asteroid
‎02-14-2023 04:12 AM

Answer

challenge_21.yxmd
Reply
0 Likes
siddharth_28
8 - Asteroid
‎02-15-2023 11:11 PM

Re: Challenge #21: Date Reformatting

challenge_21_start_file.yxmd
Reply
0 Likes
jnpac
7 - Meteor
‎02-16-2023 10:46 AM

Used regex and multi-row formulas to achieve final result

jnpac_challenge_21.yxmd
Reply
0 Likes
tmich20
8 - Asteroid
‎02-16-2023 08:30 PM
Spoiler
Screenshot 2023-02-17 152853.png

 

ALteryx Challenge 21 - Solution.yxmd
Reply
0 Likes
Minsu
7 - Meteor
‎02-16-2023 10:32 PM

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!

challenge_21_ms_solution.yxmd
Reply
0 Likes
Ed2000
8 - Asteroid
‎02-17-2023 08:07 AM
Spoiler
Ed2000_0-1676650053402.png

 

challenge_21_start_file.yxmd
Reply
0 Likes
akorte1
8 - Asteroid
‎02-17-2023 09:59 AM

Done

Reply
0 Likes
caltang
17 - Castor
17 - Castor
‎02-18-2023 12:56 AM

This is how I would do it:

 

Spoiler
caltang_0-1676710560218.png

 

Calvin Tang
Alteryx ACE
https://www.linkedin.com/in/calvintangkw/
challenge_21_start_file_caltang.yxmd
Reply
0 Likes
ed_hayter
13 - Pulsar
‎02-19-2023 07:44 AM
Spoiler
ed_hayter_0-1676821454176.png

 

challenge_21_flow.yxmd
Reply
0 Likes
Live Weekly Challenge