Challenge: 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.