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

Boni
6 - Meteoroid

Challenge 2

ojnouh33
5 - Atom

 

Captdddure.PNG

Gbenga_Opadiji
7 - Meteor

I used two select tools to make the solution easier to follow.

jyothiganti
7 - Meteor

Here is my solution for Challenge #2

Reb_harper
6 - Meteoroid

Done.

pawanmalik
8 - Asteroid

Here is my solution for this challenge.

Skrupczak
7 - Meteor

rinair- %b = Abbreviated month name, example: "Sep"

I refer to this page all the time when writing formulas: https://help.alteryx.com/2019.1/Reference/Functions.htm?Highlight=functions 

If you expand the date/time section, it has a list of specifiers and separators at the top that tell you what "code" to use based on the format the address is in, i.e. %b for appreviated month name or %B for full month name

pzuluaga
6 - Meteoroid

My solution...

hamza_khan
7 - Meteor

Done!

omercado05
7 - Meteor

Here is my solution.