I have two CSV files
1. A big list of social media posts which contain the email ID of the poster, and other data
2. A list of unique people with name, email etc
What I would like to do is select the rows from the first csv based on their email existing in the second csv. I have tried to use Stream Lookup but am thinking I am getting some really wrong.
Any advice for a new guy?