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...

4 comments

Mark M.
·
·
*without having to use multiple columns + "write to table" for each column
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!
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
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.