Clay Icon

Using Column Function to Transform Row Values into New Table Rows

ยท
ยท

Clay masters, what's the column function that will take row values across multiple columns and add them individual to a new table in a new row. e.g. Source table values in row 1 - columns 4, 5, 6, 7, 8 moved into a new table in row 1 column 1, row 2 column 1, row 3 column 1 etc...

  • Avatar of Mark M.
    Mark M.
    ยท
    ยท

    *without having to use multiple columns + "write to table" for each column

  • Avatar of Channeled
    Channeled
    APP
    ยท
    ยท

    ๐Ÿ‘‹ Hey there! Our support team has got your message - we'll be back in touch within 24 hours (often sooner!). If you haven't already, please include the URL of your table in this thread so that we can help you as quickly as possible!

  • Avatar of Bo (.
    Bo (.
    ยท
    ยท

    Hey, thanks for reaching out That is the write to table, in the write to table you can add lists or add unique values in one single integration and have it passed to a new table without any issues. this is for with a list https://www.loom.com/share/d46fd74ae9004d229142a2474ac61866?sid=440fafc1-5d4c-4ed4-bebe-449748573397 This is for without a list lhttps://www.loom.com/share/1ae0bfb385094e9d98a8e22f7ed99c40

  • Avatar of Channeled
    Channeled
    APP
    ยท
    ยท

    This thread was picked up by our in-app web widget and will no longer sync to Slack. If you are the original poster, you can continue this conversation by logging into https://app.clay.com and clicking "Support" in the sidebar. If you're not the original poster and require help from support, please post in 02 Support.