part A 1)In theData Source Interfacewindow, connect to the Homework_1_Crossfit_G

part A
1)In theData Source Interfacewindow, connect to
the Homework_1_Crossfit_Games_2019 excel file (available in
the DOWNLOAD: Course Resources lesson), and perform the following actions:
 Bring in the 2019_games_athletes_men source and enable data interpreter
 Union the 2019_games_athletes_women source to your main table
 Left join your main unioned table to the 2019_games_scores source using
the Competitorid field
2) Update and Transform your fields following the updates listed below:
 Change Ordinal field to string type
 Hide Competitorid
 Split the profilepics3key field
 Group the Age field into two groups – Under 40 and Over 40, based on their
values
3) Extract, filter and save your work:
 Place a data source filter on overall rank less than 50
 Extract the data source
 Save your workbook as a .TWBX (Full Desktop)
 Upload to Canvas