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

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

 

kaianderson
8 - Asteroid

Too easy.

Reesetrain2
9 - Comet

All,

 

My submission is attached!

Spoiler
Capture.PNG

The Macros and the workflow are attached!

Reesetrain

GaneshBo
Alteryx
Alteryx

My Solution:

dpencheva
8 - Asteroid

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.

aheikes
8 - Asteroid
Spoiler
Challenge34.JPG
AndrewS
11 - Bolide

#34

grossal
15 - Aurora
15 - Aurora

Time to work on these challenges!

Spoiler
grossal_0-1586639312558.png

 

steven4320555
8 - Asteroid

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

 

KevinTang
8 - Asteroid

quite easy one

Spoiler
Annotation 2020-04-17 183842.pngAnnotation 2020-04-17 183806.png