I want to create a table that can ingest CSVs with varying column structure (e.g. downloaded from different lead databases), and identify the fields that matter to enrich with work email.
The columns that will always exist in the CSV files are First Name, Last Name, Company Name, and Company Website. The rest of the column headers may vary.
I need my table to be able to recognize those three column names, and use them to enrich the contact's work email address. What is the best way to set this up