Altair Monarch Exercise 8 - Outstanding Official Checks

Baba_Majekodunmi_703

Exercise Info

• Application (Classic vs Data Prep Studio): Data Prep Studio
  
• Level of Difficulty (Beginner, Intermediate, Advanced): Intermediate
• Skills/Features Tested: Report Trapping, Group By, Join, Formula Field
  
• Systems of Record: Not Applicable
• Estimated Time to Solve: 15 mins
• Exercise files required are attached
  • Checking Accounts.xlsx
  • Consumer Loans.xlsx
  • Outstanding Official Checks.txt

Exercise Overview

You are a Deposit Operations Specialist and you need to perform some analysis on the list of Outstanding Official Checks that have been issued against Consumer Loans and some Checking Accounts. Specifically, you need to determine the status of these Consumer Loans and Checking Accounts are so that you can determine which Outstanding Checks you can cancel. Your manager has asked you to perform this analysis using Monarch Data Prep Studio.

Answer

• Please upload your answers below in the comment section for the exercise
• A Video Answer to the question will be published within 7-10 days on the Monarch Succcess Plan page in the 'Monarch Exercises' section.

Altair_CommunityBlog_Default-8.jpg

Checking Accounts.xlsx

Consumer Loans.xlsx

Outstanding Official Checks.txt