Clay Icon

what is the limit of columns in one table?

ยท
ยท

what is the limit of columns in one table?

  • Avatar of Daniel K.
    Daniel K.
    ยท
    ยท

    Hey there, we currently limit tables to 50k rows, 70 columns and 30 enrichments per table. We do this to ensure we can continue providing excellent performance across the board. If you've run out of rows, you can always create another table. If you've run out of columns, we'd recommend checking to see if there are any columns/enrichments that you aren't currently using. If there's anything else I can assist you with, please let me know! ๐Ÿ˜Š Have a great Tuesday, Daniel

  • Avatar of K. M.
    K. M.
    ยท
    ยท

    Hi Daniel, thank you for your answer. I was wondering is it possible to get the values from one table A to second table B only conditionally when the specific value is already not mapped in column B in table B. could you help me ?

  • Avatar of Daniel K.
    Daniel K.
    ยท
    ยท

    Hey there, happy to help! Yes, it is possible to transfer values from one table to another conditionally. You can use the "Write to Table" feature to achieve this. To ensure that the values are only transferred when a specific condition is met, such as a value not already being present in a column in the second table, you would need to use a conditional formula. This formula can be set up to check if the value exists in the target column and only write the record if it does not. You can learn more about how to use conditional formulas and the "Write to Table" feature through the provided resources: * How to Use AI Formulas: How to Use AI Formulas * Write To Table Video Explanation: Write To Table. If there's anything else I can assist you with, please let me know! ๐Ÿ˜Š Have a great Tuesday, Daniel

  • Avatar of K. M.
    K. M.
    ยท
    ยท

    Hi Daniel, thank you, it's superhelpful! Have a great day!

  • Avatar of Daniel K.
    Daniel K.
    ยท
    ยท

    You're welcome :)

  • Avatar of Channeled
    Channeled
    APP
    ยท
    ยท

    Hey there - just wanted to check in here to see if you needed anything else! Feel free to reply back here if you do.

  • Avatar of Channeled
    Channeled
    APP
    ยท
    ยท

    We haven't heard back from you in a bit, so we're going to go ahead and close things out here - feel free to let us know if you still need something!

  • Avatar of Channeled
    Channeled
    APP
    ยท
    ยท

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