Exercise Info
- Application (Classic vs Data Prep Studio): Data Prep Studio
- Level of Difficulty (Beginner, Intermediate, Advanced): Beginner
- Skills/Features Tested: Append, Join (Inner Join), Negative Join, Analyze
- Systems of Record: Not Applicable
- Estimated Time to Solve: 10 mins
- Exercise files required are attached in the Zip File Below;
- National Stock Number Extract-2-21-23.xlsx
- National Stock Number Extract-3-17-21.xlsx
Exercise Overview
You are a Budget Analyst at a Federal Agency and you want to analyze National Stock Number data to help prepare for budget season by answering the following questions:
- What is the Total Number of items grouped by "rep_office" for both Excel files?
- How many items exist on both Excel files?
- How many items don't exist on the both files? (ie, what items are on the 2-21-23 file, that are not on the 3-17-21 file, and vice versa)
Exercise Answer
Not sure you got the correct answer? No problem. Watch the video below for a demonstration of this exercise from start to finish.