Altair Monarch Exercise 9 - Patient Service Codes

Exercise Files

You can download all Monarch exercise files here: Monarch Sample Files for Exercises


Exercise Overview

You are a Patient Financial Services (PFS) Operations Analyst, and you need to identify the list of recently rejected services that were provided to patients, and those services that were not rejected, and the total amount for those lists (rejected and non-rejected)

The list of services are on the Patient.txt file which also includes the service codes. For this exercise you're only interested in the service codes that start with A. The Excel files contains a list of all Service codes that were recently rejected.

Your manager has encouraged you to use an inner join and negative join to help you answer these questions in the Data Prep Studio.


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.