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