Challenge: Joining Tables and Splitting Columns
Task
- Load the
sample_-_superstore.xlsfile 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
Abelmanordered.
¿Todo estuvo claro?
¡Gracias por tus comentarios!
Sección 1. Capítulo 5
Pregunte a AI
Pregunte a AI
Pregunte lo que quiera o pruebe una de las preguntas sugeridas para comenzar nuestra charla
Suggested prompts:
How do I split the "Customer Name" column in Tableau?
Can you explain how to perform a left join between "Orders" and "Returns" in Tableau?
What steps do I follow to sort the "Customer Second Name" column in ascending order?
Awesome!
Completion rate improved to 2.63
Challenge: Joining Tables and Splitting Columns
Desliza para mostrar el menú
Task
- Load the
sample_-_superstore.xlsfile 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
Abelmanordered.
¿Todo estuvo claro?
¡Gracias por tus comentarios!
Sección 1. Capítulo 5