Is there a way to pull multiple person data (shareholders of a company) into it's own row? Currently I have the company details and then using the companies house API to pull significant shareholders, but they all appear on the same row
Yes! You can split those shareholders into separate rows using the "Turn items into rows" feature. [1]
Here's how:
Click into the cell containing your shareholders list
Hover to the right of the list to see action options
Select "Turn items into rows" to move each shareholder into its own row in another table [2]
Alternatively, use the "Write to Other Table" enrichment:
Add Column > Add Enrichment > Search "write to table"
Select the column with your shareholders list
Map the shareholder properties to columns in your destination table [3]
This will create individual rows for each shareholder with their respective data mapped out properly. [4]
Is that what you were looking for?
I can't write to another table as it won't let me write data from two different columns into the same one in the new table
That's a common limitation. You can work around this by combining your data first, then writing to the new table.
Option 1: Merge columns first
Add Column > Merge Columns
Combine your two columns into one using a formula
Then use Write to Other Table with the merged column [1]
Option 2: Map each column separately
In Write to Other Table, use "Column mapping" mode
Enter "/" to skip list selection
Map each source column to different destination columns
Option 3: Use the newer "Send table data"
Actions > Send table data > "Send row for each item in a list"
This gives you more flexibility for complex mappings [2]
Which approach works better for your shareholder data structure?
If you still need help with managing your shareholder data or have questions about these approaches, I'm here to assist. Would you like to provide more details about your data structure or the specific issue you're encountering?
But some of the data I want to keep the same (company name) but split out the data at the end of the row into new rows. So if I have 3 shareholders in 1 row, I'd like to split them into 3 rows, all with the same company data, but with the different shareholder data in each row?
Perfect! Use Send table data with "Send row for each item in a list":
Actions → Send table data
Select your destination table
Choose "Send row for each item in a list"
Map your shareholders column as the list to split
Map company name and other static data to repeat for each row
Did that answer your question?
If you still need help with splitting your shareholder data into separate rows while keeping company details, I’m here to assist. Would you like to share more about your current setup or any specific challenges you’re facing with this process?
Hey Jonathan M., I have recently been playing around with the Companies house API. You should see the below when you call the API to get people. The two Items in the list are the two persons with significant control in this case. Feel free to DM if you want to explore further...
Perfect! You've found the right action. "Write each item to new row in other table" will split your shareholders into separate rows while preserving the company data. [1]
This creates one row per shareholder with the company details duplicated across all rows - exactly what you need for flattening your Companies House API results. [2]
Is that what you were looking for?
If you still need help with splitting your shareholder data into separate rows while keeping company details, I’m here to assist. Would you like to share more about your current setup or any specific challenges you’re facing with this process?
