Forum Discussion
How to do dynamic left anti join?
Hi,
Please share some data to work.
Enrollments (there are many columns which are related to course level)
| Course Title | start date | status | |
| [email protected] | abc | 9/12/21 | in progress |
users report (contains all the users)
| reporting department | office | job title | |
| [email protected] | Audit | Sydney | Manager |
| [email protected] | IT | QLD | Partner |
The logic is if an user is enrolled in any course, the email of that user will be there in enrollment report. If not, then the user is not enrolled.
Hi,
So if you select abc in the slicer, then in the resultant table, you want the result to be [email protected]. Am i correct? Share some more rows of data in both tables. Also, there should be a third table which should list down all courses. Share that as well.
Hi, Thats correct. I don't have any other table its just the enrollment reports it mostly contains all the courses.
Email Course Title Start Date Status [email protected] abc Not started [email protected] abc 9/12/21 completed [email protected] xyz 10/1/21 completed [email protected] xyz Not started Email reporting department office Job title [email protected] Audit NSW Manager [email protected] IT QLD Admin [email protected] IT NSW IT [email protected] Tax VIC tax So if i select abc course in slicer I should see [email protected] and [email protected] users who are not enrolled.