I got involved with a task to match two datasets that baffles me to no end. I have two sample datasets.
The first dataset has the courses that students enrolled during the term
The second dataset has the visits in tutoring centers. Here I do not have course title I have only reason for tutoring.
Using these two datasets I am trying to match courses with tutoring visits and end up with the following table:
The criteria for matching to have this table are:
a) if tutoring reason has similarity with the title of the course then tutored in course = yes
b) if a student visited a tutoring center regardless the matching of the title of the course then tutored in term = yes
c) If there is a same word in the cells (i.e. Course and Tutoring Reason) between then the two cells match
d) If there is a different but similar subject between the two cells and there is no other cell with similar word at the same term then the two cells (i.e. Course and Tutoring Reason) match
I am not sure even if that is possible through sql - How you would go to get to this table?