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]
Can't you just add 8 columns and put 1 company name from each experience in each column. Then it would be pretty easy to some formula fields checking the results against your company name column. Seems simple, what am I missing?
Jacob V. - thanks for the response. Yes I thought of that, and realised that I would have to allow for the max, which could be n=10. And If I needed the end date, this would use 20 cols. Seemed that I would burn a lot of cols for this "brute force" approach, was hoping for something more elegant.
Also, how would I write the formula to find the matching col and return an end date, and figure out if it was current?
What's your end goal with all this? Like what is your desired outcome and purpose for this?
In one section of my app (alternatives.pe) I am storing Name, Email, LI Profile of 1) Founders, 2) Directors 3) Investors in every startup in Southeast Asia I want to use Clay to a) Source this data if I cant get it directly b) make sure that the data I have stays current. ie the desired out come and purpose is to spot people who are no longer with the company that we have them associated with
Ian, maybe is better if you write all the experiences in a new table using the write to table integration: