I'm using the Write to Table function and have JSON in 14 different co...

·

I'm using the Write to Table function and have JSON in 14 different columns. Any way to combine JSON for the 14 other columns in a single Write to Table column? Or, do I need 14 Write to Table columns?

11 comments

Clay Team
APP
·
Hey hey! Can you drop the URL for your table here? (if applicable) 🫶 Don't worry, only admins will be able to open your table 😉
Kevin P.
·
This shows a single column of JSON. What's the formula to have it take JSON from other columns as well?
Kevin P.
·
https://app.clay.com/workspaces/13479/tables/t_OqbMYSMouZB8/views/gv_aikQnr2jC6Pj
Clay Team
APP
·
Hey Kevin, thanks for reaching out! Taking a look
Kevin P.
·
you're awesome Arturo
Clay Team
APP
·
Hmm, so you're looking to kind of "transpose" each topic into individual rows?
Kevin P.
·
ya, the topic that already has it's own JSON column
Kevin P.
·
it's fine, i can make 14 individual "send to table" columns if i need to
Clay Team
APP
·
I know it's not ideal but not sure if it will read them as a list. Maybe using a formula to combine them in a single cell and then Write them over but not sure our integration can detect JSON as a list though
Kevin P.
·
yea, and the cell limits get reached quickly
Clay Team
APP
·
Yup, also tested this out with the recent JSON format option for chatGPT but it's still quite a bit of data. That alternative of having several columns unfortunately seems like the best way for now, you can always duplicate the column to keep the settings and just change the one field