So I need to build a movie recommendation system for this uni project. What I'm stuck in right now is to get the difference between two tables, BUT:
Table 1 has:
User ID - Movies ID - Rating
Table 2 has:
Movie ID - Category Bitvector
What I need to do is to get the Movie ID each user hasn't rated/watched yet. So I need a table with, for each user, the difference between table 2 and 1, that are the movies that aren't listed in table 1.
I've tried using Reference row filter for only 1 user, and tried iterating with Group loop, but it only gives me the first group of users which is User ID 1. So I'm stuck in here.
Here is a picture of my current state:
Any help is appreciated, and thanks in advance!