Skip to main content

Morning! I have a pretty simple data set.

 

One table is a list of student names - meaning every student is in this list.

 

The other table is a list of historical classes that students have taken. This means that only the student that have taken a class show in this list.

 

What I am trying to figure out is this - for each class which of the 5 students have and have not taken each class?

 

Because both tables do not have a course listing, I am not able to join on some sort of course ID. So I am not sure what is the best approach to solving this issue - join or a calc?

 

Thanks,

 

Scott

 

@Michael Hesser​ 

8 réponses
0/9000