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 #34: Date-Time Formatting

atcodedog05
22 - Nova
22 - Nova
‎03-26-2020 10:13 AM

On a spree to binge complete weekly challenges

 

Smooth and easy

 

Spoiler

This is my solution

atcodedog05_0-1585242111971.png


Macro

atcodedog05_1-1585242150603.png

 

challenge_34_atcodedog05_Solution.yxzp
Reply
kaianderson
8 - Asteroid
‎03-26-2020 03:25 PM

Too easy.

challenge_34_completed_ka.yxzp
Reply
0 Likes
Reesetrain2
9 - Comet
9 - Comet
‎03-27-2020 05:02 PM

All,

 

My submission is attached!

Spoiler
Capture.PNG

The Macros and the workflow are attached!

Reesetrain

Challenge_34_Reesetrain_Submission.yxmd
Challenge_34_Reesetrain_Submission_Macro.yxmc
Reply
0 Likes
GaneshBo
Alteryx
Alteryx
‎04-01-2020 02:27 AM

My Solution:

challenge_34_GB.yxzp
Reply
0 Likes
dpencheva
8 - Asteroid
‎04-02-2020 06:00 AM

Here is my solution. I created two Macros. The first one is with 6 steps and the second one is only with only one task.

challenge_34_solution_file.yxmd
Parce_Dates.yxmc
Parce_Dates_long.yxmc
Reply
0 Likes
aheikes
8 - Asteroid
‎04-02-2020 04:55 PM
Spoiler
Challenge34.JPG
challenge_34_AH.yxzp
Reply
0 Likes
AndrewS
11 - Bolide
‎04-11-2020 06:19 AM

#34

C34.yxzp
Reply
0 Likes
grossal
15 - Aurora
15 - Aurora
‎04-11-2020 02:08 PM

Time to work on these challenges!

Spoiler
grossal_0-1586639312558.png

 

challenge_34_grossal.yxmd
Reply
0 Likes
steven4320555
8 - Asteroid
‎04-15-2020 10:19 AM

Used first principle (the default date-time format of Alteryx), applied PadLeft function.  

 

Spoiler
steven4320555_0-1586971089801.pngsteven4320555_1-1586971138723.png

 

Actually, the built-in DateTime parser can handle such data.

steven4320555_0-1586971740361.pngsteven4320555_1-1586971808712.png

 

challenge_34_steven.yxzp
Reply
0 Likes
KevinTang
8 - Asteroid
‎04-17-2020 03:40 AM

quite easy one

Spoiler
Annotation 2020-04-17 183842.pngAnnotation 2020-04-17 183806.png
Reply
0 Likes
Live Weekly Challenge