Clay Icon

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

  • 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 Mark C.
    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.

  • Avatar of Mark C.
    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

  • Avatar of LuisArturo
    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.

  • Avatar of Mark C.
    Mark C.
    ยท
    ยท
  • Avatar of Mark C.
    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.

  • Avatar of Mark C.
    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.

  • Avatar of Mark C.
    Mark C.
    ยท
    ยท

    It's definitely my account ID as I got another clay user to try the same, and it worked fine.

  • Avatar of Daniela D.
    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.

  • Avatar of Mark C.
    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.

  • Avatar of LuisArturo
    LuisArturo
    ยท
    ยท

    Hey there Mark thank you for the additional detail will share it with the team.

  • Avatar of Mark C.
    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"?

  • Avatar of Mark L.
    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?