Clay Icon

How to Limit Array Results When Writing to a New Table

ยท
ยท

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?

  • Avatar of Channeled
    Channeled
    APP
    ยท
    ยท

    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.

  • Avatar of Channeled
    Channeled
    APP
    ยท
    ยท

    Did that answer your question?

  • Avatar of Channeled
    Channeled
    APP
    ยท
    ยท

    Hi Jennifer B.! This thread was recently closed by our Support team. If you have a moment, please share your feedback:

  • Avatar of Jennifer B.
    Jennifer B.
    ยท
    ยท

    GPT saved me. Can add it in the formula.

  • Avatar of Channeled
    Channeled
    APP
    ยท
    ยท

    That's great! I'm happy to hear GPT was helpful for you. I'm here if you need any further assistance.