Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

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
SOLVED

Challenge #125: US Grand Prix Lap 1 - Data Prep

Steph_Maddrell
8 - Asteroid

10 minutes! Some of it spent trying to sort the duplicate employee ID before I realised this wasn't asked for in the objective...

 

Speed version:

Spoiler
Redundant tools all over the place!
Steph_Maddrell_0-1621788058865.png

Tidy version:

Spoiler
Steph_Maddrell_2-1621788306679.png

 


Steph_Maddrell_1-1621788262716.png
Laurap1228
11 - Bolide

Here is my solution:

Spoiler
Laurap1228_0-1622124869949.png

 

Qiu
20 - Arcturus
20 - Arcturus

Nice one!

Spoiler
Challenge_125.PNG
vbrown
8 - Asteroid

My solution.

euanwilson
8 - Asteroid
Spoiler
So as the preamble stated I joined the two data sets on Employee Number.
To convert the date columns to 'Date' fields I used two DateTime tools and then the select tool to remove the columns that stored the relevant data as strings. 
To convert the Pay rate to a 'Double' field I first used the formula tool and the Replace function to remove the dollar sign from the column entries and then a select tool was used to change the field to a 'Double'. 
Finally, again as the preamble stated I used the Field Summary tool with the O anchor output to display the data as shown in the given output.

Workflow.PNGResults1.PNGResults2.PNG
Pkoziol
6 - Meteoroid

First time used Field Summary. Very useful.

Spoiler
Pkoziol_0-1624029396388.png

 

Erin
9 - Comet

First time using the Field Summary tool! Time 00:06:45

Spoiler
BronzeFox_0-1624048008853.png

 

derekbelyea
12 - Quasar
Spoiler
derekbelyea_0-1624573934974.png

 

ncrlelia
11 - Bolide

Challenge 125

Jonny
11 - Bolide

my solution:

Spoiler
Jonny_0-1625577657469.png



Jonny_1-1625577710007.png