Create Rows for Primary and Secondary Company Combinations in Clay
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