not geting my point
i have data in table 1 from different sources, that have similar ccompanies most of the times but there are new as well
so i am writing companies in table two, enriching them there and using AI to scrape websites aswell
than in table 1 i lookup for companies in table 2 if they are already there they gets populated in table 1
if not they gets written in table 2 enriched there and using the lookup again in table 1 they gets populated in table 1
i have three columns in table 1
lookup companies in table 2, if not found write these comanpies to table 2,lookup again for new written companies