Can I link two tables from CSV imports?

·Aug 07, 2024 04:05 PM

Hey, Wondering if it is possible to connect 2 tables from csv imports. I have a list of companies and people at those companies. I want to have them on separate tables as I am running out of columns when enriching both. Is there a way I can link them and reference them in the other?

3 comments

· Sorted by Oldest

Nnabuike O.
·
you’re running out of columns? as in, hitting 75 columns everytime you import?
Toby S.
·
After running the enrichment for both the company and starting the account yes
Gugulethu M.
·
split the CSV into two separate files: one for companies and one for people, and upload them individually. you can use actions like "Write to Other Table", "Lookup Multiple Rows in Other Table", and "Lookup Single Row in Other Table" to connect and reference data across your tables once the data is uploaded. Hope that helps!

Nnabuike O.
·
you’re running out of columns? as in, hitting 75 columns everytime you import?
Toby S.
·
After running the enrichment for both the company and starting the account yes
Gugulethu M.
·
split the CSV into two separate files: one for companies and one for people, and upload them individually. you can use actions like "Write to Other Table", "Lookup Multiple Rows in Other Table", and "Lookup Single Row in Other Table" to connect and reference data across your tables once the data is uploaded. Hope that helps!