Comparing 2 subsets of tables

msciarrino · ‎01-24-2024

Hello Everyone,

I have 2 tables of data. 1 is the orders that have been placed and 2nd is a complete list of all the bill of materials we need to purchase for every parent tool. Below is a very simplified version of my data. In reality, there are hundreds of parent tools that can be purchased multiple times(along with all of their child parts) and BOMs can have up to 50 children.

My goal is to determine 3 things:

1. Know when something wasnt purchased from the bill of materials (example Child3 wasnt purchased in above data)

2. Know when too many of the items that are in the bill of materials are purchased (example Child4 purchased too many in data above)

3. Know when something has been purchased that was not in the bill of materials (example a Child5 was purchased but it is not in the bill of materials)

I would like to show graphically all the count of the problems based on the above criteria, then drill down into a list of the specific problems.

I dont have any idea of where to start. If anyone can point me to some information or a youtube video with something similar I would greatly appreciate it.

Thanks.