How to Limit Array Results When Writing to a New Table

Jennifer B. · 2025-02-18T10:09:38.488813+00:00

I've got an array i want to write to a new table, but I only want 2 results maximum. Whats the best way to do this?

You can use the "Write to Table" integration to write your array to a new table. Here's how: 1. Select a destination table (or create a new one) 2. Choose the column containing your array 3. Map the array data to your new table columns 4. Set a limit of 2 results in your source data configuration (similar to how the "Limit" parameter works in other integrations) The Write to Table integration supports writing lists, single values, or objects, giving you flexibility in how you transfer the data. Make sure your array is properly formatted as a list - if you encounter any errors, you may need to add the list through the "Other data from this table" section.

Sources: Write to table integration overview | Documentation | Clay University Write to Other Table with Clay Labs Find Contacts with Clearbit

5 comments