In case you missed the announcement: The Alteryx One Fall Release is here! Learn more about the new features and capabilities here
ACT NOW: The Alteryx team will be retiring support for Community account recovery and Community email-change requests after December 31, 2025. Set up your security questions now so you can recover your account anytime, just log out and back in to get started. Learn more here
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 #34: Date-Time Formatting

CMWalsh
8 - Asteroid
‎06-15-2022 03:21 AM
Spoiler
CMWalsh_0-1655288399925.png

 

Found the wording of this challenge a bit misleading... have a proper look at the example output before you get started!

challenge_34_start_file.yxzp
Reply
0 Likes
Abiramm1
8 - Asteroid
‎06-19-2022 05:54 AM

This is tagged as difficult, maybe the text to columns is better than it used to be but all the numbers worked nicely :)

Weekly challenge 34 solution.yxmd
Macro challenge 34.yxmc
Reply
0 Likes
NhungLe
8 - Asteroid
‎06-23-2022 03:02 AM

#34

challenge_34_NhungLe.yxzp
Reply
0 Likes
kglearner
7 - Meteor
‎06-24-2022 06:45 AM
Spoiler
kglearner_0-1656078313666.png

 

Challenge_34_KG Solution.yxzp
Reply
acarter881
12 - Quasar
‎06-26-2022 08:20 PM

Here's my batch macro solution (also did a standard macro).

Spoiler
my_weekly_challenge_34_solution.png
challenge 34 - my batch macro.yxmc
Reply
0 Likes
Amol_Telore
11 - Bolide
‎07-06-2022 02:16 AM
Spoiler
Amol_Telore_0-1657098986864.png

 

challenge_34_start_file.yxzp
Reply
0 Likes
BenoitC
Alteryx
Alteryx
‎07-15-2022 12:18 AM

Done !

 

Spoiler
BenoitC_1-1657869469484.png

 

BenoitC_2-1657869483386.png

 

Benoit Conley

Sales Engineer
Alteryx, Inc.

challenge_34_start_file.yxzp
Reply
0 Likes
Albert_Vega
8 - Asteroid
‎07-16-2022 09:24 AM

Done!

challenge_34_start_file.yxzp
Reply
0 Likes
sgreenough
8 - Asteroid
‎07-19-2022 04:57 AM

Solved!

challenge_34_solution.yxzp
Reply
0 Likes
AlexEntz
8 - Asteroid
‎07-27-2022 04:54 AM

My two Solutions:

 

Spoiler
AlexEntz_0-1658922786743.png
Spoiler

AlexEntz_1-1658922807933.png

 

 

challenge_34_start_file.yxmd
Reply
0 Likes