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

Need Assistance Merging Lookalike Company Data into Two Columns in Clay

Hi Clay team, the write to table comes up with "Invalid credentials". I'm looking to get my table with lookalikes up asap if possible. Initially I created new columns for each "Lookalike Company name" and "lookalike domain" resulting in 9 additional columns (Clay wouldn't let me write it to the existing "Company name" and "Company Domain" column which seemed a little confusing? Then I realised you need to write it to a new table! Can you please help me sort through this data so I have it in 2 columns only. FYI. I've not added any additional columns of data as I'd have to now do it for all 9 columns, but if you can help with that too, I won't have to re-enrich it all and use new credits in the new table. https://app.clay.com/workspaces/236043/tables/t_dCrrYS37bAmc/views/gv_z9zvPqx9QoWn

23 comments

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
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"?
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 :)
Mark C.
·
·
Bo (. Can you please add my assistant who has applied to the community but hasn't been accepted Harry B
Bo (.
·
·
Hey - Can you tell us to send us a message with their LinkedIn URL and a proof that it's them? We will send them an invite once they do so :)
Mark C.
·
·
they already have sent those, thats why i'm following up.
Bo (.
·
·
which infos did they contacted us with?
Mark C.
·
·
I DM'ed you earlier with their details.
Bo (.
·
·
I don't have it. Might've sent it to a different account but let's keep the conversation here :) That might be through another ticket! I would recommend having them send us a message for faster resolution :)
Bo (.
·
·
Good news! Happy to report that we heard back from the team and this issue should be fixed. Thank you for your patience as we worked on it. Please let us know if the problem has been resolved on your end, or if you still have trouble.
Channeled
APP
·
·
Hi Mark C.! This thread was recently closed by our Support team. If you have a moment, please share your feedback: