AnsweredAssumed Answered

Selecting rows from a csv file based on values in another csv file

Question asked by Matthew Hardman Employee on May 13, 2019

Hi all,

 

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?

 

Thanks!

Outcomes