please explain step by step on how to do the following with Tableau Prep.

Objective:

Generate the desired output

Input:

$9.$csv files containing Summer Olympics Medalists data from $1976$ to $2008$

$1.$csv file containing all the host cities of the Summer Olympics from $1976$ to $2008$

$1.$csv file containing all the countries that participated in the summer Olympics from

$1976$ to $2008$

Desired Output:

Year$-$date; cannot be null

A calculated field; the year of the specific medalist row $($month and day can

both default to Jan $1)$

Host$\_$City $-$ string; cannot be null

The place that hosted the summer olympics for that year

Sport $-$ string; cannot be null

The overarching sport category that the medalist participated in

Discipline $-$ string; cannot be null

The specific sport that the medalist participated in

Event $-$ string; cannot be null

The event that the medalist participated in

Event$\_$gender $-$ string; can be null

The genders that participated in the event

This field should only have the values "Male", "Female", and null

Surname $-$ string; cannot be null

The Surname of the medalist

Given$\_$Name $-$ string; cannot be null

The Given name$/$s of the medalist

Gender $-$ String; cannot be null

The gender of the medalist

Country $-$ String; cannot be null

The country that the medalist represented

Medal $-$ String; cannot be null

The type of medal that the medalist received

Hints:

Your Final Output should have $11$ Columns and $15,221$ Rows $(15,222$ including the

header row$)$

Under the Country$\_$ID column, $"$US$"$ and "USA" both refer to the United States of

America. It is up to you whether to group all values as $"$US$"$ or to group them all as

"USA".

Assume that any row with a blank given name after the first split is dirty data, making

it valid to exclude null given names

It is easier to complete all clean steps before conducting any JOINS

In the Event$\_$Gender field, the value $"x"$ refers to neither men nor women.

It could help to not change the data type of the Year field; at least not until the end of

the flow

You would most likely use the YEAR$(),$MID$(),$ and DATEPARSE$()$ functions for

your calculated fields

Strictly follow all naming conventions indicated on the Desired Output section. This

will serve as the data model that all new files will follow for the purposes of data

hygiene.