Tammy C.

Aditi S. - not sure that would solve the issue - would we be able to do a look up against only the cities w/ the specific company? It sounds like your work around is saying to put in all the cities regardless of the company and find people associated to the cities regard less of companies-

any way you can show me in a loom? I feel like I've been told to do things multiple ways and I originally started this request by using Claygent

how do you do it by column level - claygent?

just checking in - thanks!

Also I don't think this is also addressing the issue of looking for the specific person in the specific location. The criteria I'm looking to meet would be find the people located in that particular location. An example might be if Coca Cola exists in 5 states I'm only interested in the people located in 1 or 2 states. This is applicable for all the companies listed. With that being said I understand the requirement is to have website domain in order to find people. So we have website domain and the people (w/ the titles/job function I'm looking for) how do I further than filter for location? Some of the domains are completely wrong - bbh and mapquest has nothing to do w/ any of the companies listed, somehow it is pulling that data in and I do not want to find people from these domains - how do I further filter this out as well?

Thanks Amit K. what happens if the domains are incorrect, is there a way to filter it so only some domains run?

yes - thanks - its the keenan missing tab - https://app.clay.com/workspaces/654393/workbooks/wb_0t37rlxmDBtoVvZ6pgN/tables/t_0t3ilnuceWticq6ov75/views/gv_0t3ilnumSHQcrmT55os

can you please tell me how to do this or send me documenation?

How would I get the waterfall to trigger for the all the people that were pulled from the people search query where some populated in one waterfall column and some in another and there are nested folks - (6 folks found) I have to click through into each to expand and view- how does this work for getting the find email

Hi Amit - yes, however all the data is like your first gif - it is nested inside the table - is there away to extract it so i can get the contact info?