So my specific use case. I enriched companies (table A), and varified the domains.
In my People enrichment (table B), I am missing domains for these people. There are some updates to these people via their linkedin's but that's a problem for another day.
I want to import the Domain (Column A) from the enriched company(Table A), and add it to the enriched person's (Table A) row.
I am using the Hubspot ID for the company as the identifier. (Column B in Table A) and (Column B in table B)
Table A:
Company X: HS ID 123, Domain qwe
Company Y: HS ID 456, Domain tyu
Table B:
Person A: Company X, Company Domain __, Company HS ID 123
Person B: Company X, Company Domain __, Company HS ID 123
Person C: Company Y, Company Domain __, Company HS ID 456
I need to push the domain from Table A into the rows on Table B. But I need it to base the data on the HS ID's from both tables. When I do the Multi Row and Single Row, I either have to individually type in the HS ID per search, or I do the / but it only pulls rows from Table B.
I'm not seeing an easy way to do this in masse.
