Challenge: Joining Tables and Splitting Columns
Task
Load the
sample_-_superstore.xls
file into Tableau.Perform a left join on the "Orders" and "Returns" tables.
Split the "Customer Name" column into "Customer First Name and "Customer Second Name", as demonstrated in the previous chapter.
Name the two new columns accordingly and sort the "Customer Second Name" column in ascending order.
Ensure that the first entry in the "Customer Second Name" column is
Abelman
.Identify the product that
Abelman
ordered.
Video Player is loading.
Loaded: 0%
Current Time 0:00
/
Duration -:-
- , opens subtitles settings dialogsubtitles settings
- subtitles off
- , selectedEnglish Captions
1x
- 2x
- 1.5x
- , selected1x
- 0.5x
This is a modal window.
The media could not be loaded, either because the server or network failed or because the format is not supported.
Beginning of dialog window. Escape will cancel and close the window.
End of dialog window.
Alt var klart?
Takk for tilbakemeldingene dine!
Seksjon 1. Kapittel 5
Spør AI
Spør AI
Spør om hva du vil, eller prøv ett av de foreslåtte spørsmålene for å starte chatten vår