Notice: This page requires JavaScript to function properly.
Please enable JavaScript in your browser settings or update your browser.Learn Challenge: Joining Tables and Splitting Columns | Introduction to Tableau
Tableau Fundamentals

bookChallenge: Joining Tables and Splitting Columns

Task

  1. Load the sample_-_superstore.xls file into Tableau.
  2. Perform a left join on the "Orders" and "Returns" tables.
  3. Split the "Customer Name" column into "Customer First Name and "Customer Second Name", as demonstrated in the previous chapter.
  4. Name the two new columns accordingly and sort the "Customer Second Name" column in ascending order.
  5. Ensure that the first entry in the "Customer Second Name" column is Abelman.
  6. Identify the product that Abelman ordered.
question mark

What is the quantity of the product Abelman ordered?

Select the correct answer

Everything was clear?

How can we improve it?

Thanks for your feedback!

SectionΒ 1. ChapterΒ 5

Ask AI

expand

Ask AI

ChatGPT

Ask anything or try one of the suggested questions to begin our chat

Suggested prompts:

Ask me questions about this topic

Summarize this chapter

Show real-world examples

Awesome!

Completion rate improved to 2.63

bookChallenge: Joining Tables and Splitting Columns

Swipe to show menu

Task

  1. Load the sample_-_superstore.xls file into Tableau.
  2. Perform a left join on the "Orders" and "Returns" tables.
  3. Split the "Customer Name" column into "Customer First Name and "Customer Second Name", as demonstrated in the previous chapter.
  4. Name the two new columns accordingly and sort the "Customer Second Name" column in ascending order.
  5. Ensure that the first entry in the "Customer Second Name" column is Abelman.
  6. Identify the product that Abelman ordered.
question mark

What is the quantity of the product Abelman ordered?

Select the correct answer

Everything was clear?

How can we improve it?

Thanks for your feedback!

SectionΒ 1. ChapterΒ 5
some-alt