Need Assistance Merging Lookalike Company Data into Two Columns in Clay | Clay

Need Assistance Merging Lookalike Company Data into Two Columns in Clay | Clay

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!
Mark C.
·
·
On double checking new tables don't appear to be showing for me to select when I select the "write to table" function. When i go back in to the table list they def exist and are there.
Mark C.
·
·
The tables have now appeared so it must be a caching issue. I'm now getting invalid credentials when I try to write to this table. https://app.clay.com/workspaces/236043/tables/t_Y4asRmpKanJT/views/gv_VBEBGShteHQP
Loading attachments
LuisArturo
·
·
Hey there Mark thanks for reaching out, taking a look just want to confirm a couple things, first this is for the "Air Sys Table" correct. And second you are using the Account Key under your own name and not becca's correct.
Mark C.
·
·
https://www.loom.com/share/5030c6a0d955441b8fc967c2888e5445 I'm using my own account key.
Mark C.
·
·
I've tried writing to another table, there seems to be recurring caching issues, as I'll create a new table to write to and it won't exist in the field you select the table from in the "Write to table" function. I also thought it might be because I'd housed the tables in a folder and there might be a bug, but that doesn't seem to be the issue either. I wonder if there is a workaround, as I need to get this sent out today to the client.
Mark C.
·
·
LuisArturo Do you want to check my credentials under my name as I've had a few issues, and tried trouble shooting a bunch of times with different work arounds.
Mark C.
·
·
It's definitely my account ID as I got another clay user to try the same, and it worked fine.
Daniela D.
·
·
Hey Mark! Thanks for reaching out. Sorry about this. I made a quick video walking through the error here: https://share.cleanshot.com/fftqfB2P New table not showing: I was able to reproduce this successfully (video link here:https://share.cleanshot.com/kzYTvy09). It looks like we've got a bug on our hands - I've escalated this over to our engineering team and we'll let you know as soon as we know more! Apologies for the inconvenience.
Mark C.
·
·
Thanks Daniela, thats really helpful! The caching issues is something you should look in to as it;s happened more than once while trying to write to table.
LuisArturo
·
·
Hey there Mark thank you for the additional detail will share it with the team.
Mark C.
·
·
Daniela D. unfortunately this is still not working for the clay table I'm working on here: I've tried "select a table to write to" and selecting a new table each time. When I add to "Select a list from a column" it comes up with a red box and won't write to the table and comes up with the error "Please add a valid list here." What is meant to go in this as a "valid list"?
Loading attachments
Mark L.
·
·
You know how sometimes an enrichment will return data, and it will have many results all bundled into one cell? "Find People at Company", for example, where a cell might show "12 people found": https://downloads.intercomcdn.com/i/o/w28k1kwz/1236992979/6b953a8abd680f5d62452396b54d/20241101-60596-valid-list.png?expires=1730494800&signature=cc0fde91987595b4247f33b86f3a756e84cda266e0fbba93e4534445146c739c&req=dSIkEMB3n4hYUPMW1HO4zdw2IHzeXI8UJkYNnr2d7g%2FR1rX%2BfT4HRScFnV%2B%2F%0AdaxY%0A That's what the message is referring to – a group in a cell that Clay needs to break apart into separate rows in a new table. That bulleted list icon distinguishes them. That said, if you simply need to copy/write columns from a row (rather than "unpack" items in a cell)... you can skip past the "Select a list from a column", and just use the "Add other data from this table" section below. There, you can Add individual columns you want to write from, and match them to columns in your destination table you want to write to. Does that help?
Mark C.
·
·
Thanks Mark L. Thats helpful! I guess I wasn't sure if you unpack the cell in new columns in the existing table or in "write to a new table".
Bo (.
·
·
Totally get it! Let us know if there's anything else we can do for you :)