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

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
12 - Quasar
‎02-19-2023 07:44 AM
Spoiler
ed_hayter_0-1676821454176.png

 

challenge_21_flow.yxmd
Reply
0 Likes