Notifications
Clear all
Power Query
4
Posts
3
Users
0
Reactions
60
Views
Topic starter
i want a suituation when a studentId as contained in sheet 1 does not match in the accredited sheet called accreditation, please remove the row of record containing that student, in sheet1, since the student was not accreditated prior to taking the the courses.
How do i achieve this.
Thank you, i will love to see the solutions to this puzzle.
See the attached file:
Posted : 06/06/2023 12:41 am
Hi,
No file attached.
Phil
Posted : 06/06/2023 12:59 am
Topic starter
This is the attachments below
Posted : 06/06/2023 1:32 am
One way would be to merge the accreditations with the course list (left outer join) as demonstrated in the attached file.
Posted : 06/06/2023 1:56 am
