Create Rows for Primary and Secondary Company Combinations in Clay

Jake S. · 2025-04-03T14:12:08.284899+00:00

I want to loop over a specific row in Clay to Write to Other Table. I have a field "Primary Company" then another field, "Secondary Companies" which is a list that looks like this (attached). I want to Write to Other Table for every primary company and secondary company combination. Ex. I have Nike as a Primary Company. Then my Secondary Companies include Jordan Brand, Nike By You, Nike Design Exploration, etc. - we should make individual rows for the primary company with a specific secondary companies for all primary/secondary company combinations

To loop over a specific row and write to another table for every primary and secondary company combination, you can use our "write to table" feature. Here's how: 1. Set up a "write to table" action in your workflow. 2. Select the column containing your list of secondary companies. 3. Map the primary company and each secondary company to columns in the destination table. 4. Configure the action to create a new row for each combination. This will create individual rows for each primary/secondary company pair. For example, if Nike is your primary company, you'll get separate rows for Nike + Jordan Brand, Nike + Nike By You, etc.

Sources: Write to Table [Clay 101] - Clay University Write to Other Table | Documentation | Clay University

4 comments