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
21 - Polaris
21 - Polaris

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