Is there a way to merge rows while preserving data

Question

Is there a way to merge rows while preserving data?  For example, i upload a list of companies with multiple physical locations and each location is its own row.  Is there a way to create one company row and then fill the location data into multiple columns within that row?  Would it better if i did this via python script before importing to clay?

GTM Practitioner · Accepted Answer

Send data to one master table and then dedupe. You'll have all your tables preserved and then a table with all the data to do whatever with.

GTM Practitioner · Accepted Answer

I don't want to dedupe them. I want to combine the location data under one row.

I actually just did it locally using a python script before importing instead. Seemed simpler than trying to do it in clay

GTM Practitioner · Accepted Answer

Importing companies with multiple physical locations to enrich for local rankings (and other enrichments) and then find people at company.

Don't want to enrich each location as its own entity. The only enrichment i want to run for each location is the ranking tracker.

Is there a way to merge rows while preserving data

3 Answers

Add your take