Clay Icon

Request for Enhanced Data Combination Feature in Clay

·
·

Feature request -> Can Clay PLEASE have some mechanism to combine data from multiple cells (in a row) without the 8kB limitation? Not breaking up JSON into chunks. Not compressing. Some mechanism (alternative) to get the combined data out for further processing. My teammate needs to copy-paste all those cell values manually for their custom downstream task right now. Would help a lot!🙏 I am going to try to set up my own server and then pass information via the HTTP API enrichment. IDK if that would work. But some better in-built functionality has to be there.

  • Avatar of Channeled
    Channeled
    APP
    ·
    ·

    Yes, we can help you combine data from multiple cells in a row without the 8kB limitation. Our "write to table" feature allows you to transfer data between tables, and then you can use the Merge Columns feature to combine data from different columns. Here's how you can do it: 1. Use the "write to table" feature to transfer your data to a new table. 2. In the new table, click "Add Column" and select "Merge Columns". 3. Input a formula to combine the desired columns. This method allows for easier processing of larger amounts of data. For more details, check our guides on the Write to Table integration and Merge Columns feature on our website.

  • Avatar of Summiya B.
    Summiya B.
    ·
    ·

    Use write to other table function

  • Avatar of Channeled
    Channeled
    APP
    ·
    ·

    To combine data from multiple cells in a row using the "write to table" function while working around the 8000 character limit per cell, you can: 1. Use multiple columns in your destination table to split the data. 2. Utilize the "Write to Other Table" feature to map different source columns to separate destination columns. 3. In the destination table, use formulas or Clay's data processing features to combine the split data as needed. Remember, you can write individual values or lists to the destination table, depending on your column setup. This approach allows you to work with larger datasets while respecting the 8000 character limit per cell.

  • Avatar of Bruno R.
    Bruno R.
    ·
    ·

    Hi Jayant, totally hear you — we’ve shared this feedback directly with our product team, and they’re actively exploring how to address it from a technical perspective. We’ll be in touch as soon as we have more information on a potential feature to support this!

  • Avatar of Channeled
    Channeled
    APP
    ·
    ·