Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.
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

tosdrive
6 - Meteoroid
‎03-16-2023 12:20 PM

tosdrive_0-1678994360228.png

 

c_21workflow.yxdb
Reply
0 Likes
BS_THE_ANALYST
14 - Magnetar
14 - Magnetar
‎03-16-2023 01:26 PM

Nice! Tried to take a route using a lookup table via generate rows:

Spoiler
BS_THE_ANALYST_0-1678998391780.png

 

All the best,
BS
LinkedIN

Bulien
challenge_21_BS.yxmd
Reply
0 Likes
PrachiD
8 - Asteroid
‎03-16-2023 07:37 PM

Submission for ADV challenge_21_ Adv data Prep using Text to column, find replace and multirow

Submission for ADV challenge_21_ Adv data Prep.yxmd
Reply
0 Likes
Sebastian_Chaieb2
9 - Comet
9 - Comet
‎03-23-2023 07:57 AM
Spoiler
Sebastian_Chaieb2_0-1679583397957.png

 

challenge_21_Solution_SC.yxmd
Reply
0 Likes
elaineyuan
8 - Asteroid
‎03-24-2023 02:45 PM

Last challenge today!

 

Spoiler
challenge_21_elaine_yuan.png
challenge_21_elaine_yuan.yxmd
Reply
0 Likes
Hammad_Rashid
11 - Bolide
‎03-25-2023 05:51 AM

Screen Shot 2017-08-27 at 18.22.13.png

Challenge_21_HR.yxmd
Reply
0 Likes
Amilley
8 - Asteroid
‎03-27-2023 09:47 AM

**Spoiler**

 

 

I used some batch concepts leveraging the multi-row... curious on how others tackled as well.

 

Amilley_0-1679935616113.png

 

challenge_21_Solution_03.27.2023.yxmd
Reply
0 Likes
mg46
8 - Asteroid
‎04-07-2023 02:20 PM

Here's my solution.

 

Spoiler
mguarniere_0-1680902414908.png

 

 

challenge_21_Michelle_G.yxzp
Reply
Powerhouse_21
10 - Fireball
‎04-17-2023 09:32 AM
Spoiler
Powerhouse_21_0-1681749149942.png

 

PH21_Challenge_21.yxmd
Reply
0 Likes
scooby_snacks
8 - Asteroid
‎04-18-2023 01:29 AM

My solution. 

challenge_21_solution_scooby_snacks.yxmd
Reply
0 Likes