Hi I need some help figuring out a way to do this.
I have lists of many thousands (maybe 10k plus) people , where I have an "Expected" current company (in this table it is the col I_Co_Name - when I enrich via LinkedIn, I get a list of experiences (in this case for Ana Paula Gonzalez = 8 ). I need to cycle through the list ( 1 to n) applying some logic
a) Does the company Experience n match the expected company in I_Co_Name and if so what was the End_Date and Is Current"
b) Does Company Experience n fit some criteria (simplest way is via a look up to another table) [ in broad terms is it a VC/Investor type company]