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 #2: Preparing Delimited Data

Nicholas_White
8 - Asteroid

Hi,

 

My second Weekly Challenge 🤣

 

Spoiler
vitaminman12_0-1660671172521.png

 

Thanks,

 

Nick

Nicholas_White
8 - Asteroid

Hello,

 

@Antonio1969 

 

The original date:

 

16-JUN-01

 

Its format is broken up like this:

 

16: dd

JUN: Mon.

01: yy

 

When you put this back together with the hyphens, the format looks like this:

 

dd-Mon.-yy  

 

 

So, if you select dd-Mon.-yy as your format, the date will convert.

 

vitaminman12_0-1660671580642.png

 

Try that format in the DateTime tool, and it will work.

 

Good luck,

 

Nick

Pete_Rodgers
Alteryx
Alteryx

first attempt, using tools and minimal code

Spoiler
Pete_Rodgers_0-1660754907780.png

 

erickyaparevalo
6 - Meteoroid

Hi,

 

first time sharing solving a weekly challenge here. Here you can find my solution. In fact, they are two. One using RegEx tool and another using Formula tool with RegEx inside. Maybe someone will find it interesting to check some basics on RegEx. Learning Regex step forward your level on parsing data. I encourage you to skill on it!

erickyaparevalo_0-1660737952167.png

 

bwins
8 - Asteroid
Spoiler
bwins_1-1660740929598.png

 

 

Angelica_Obi
8 - Asteroid

b156074c-db04-45d0-ab6a-90b5341cb671.png

My first Alteryx challenge completed 

 

 

CammyPhillips
8 - Asteroid

My Solution :)

 

Spoiler
CammyPhillips_0-1660755656775.pngCammyPhillips_1-1660755688121.png

 

 

Muhammadmaaz
7 - Meteor

My Soultion

JHerzog5839
7 - Meteor

Spoiler

Daniel_DB
5 - Atom

Thanks!