Clay Icon

Storing Lookalike Company Data with Comma-Separated Keywords and Locations

Β·
Β·

Hi, so i am using clay company lookalikes feature. and it gave me 10 companies data from one url which is perfect. and then i am sendign that data (10 companies) to "write to table" in a sperate one. all working ok till here. but as seeen in the screenshot in each fo the record for those 10 companies, in the first table i am seeing keywords returned as array maybe cuz thay're more 5-6 etc an same issue with locations and other columns. now how should i send that info so it can be stored in the new table in in respective row but the keywords must be comma seperated in a single cell, same with locations. how can i do that?

  • Avatar of Channeled
    Channeled
    APP
    Β·
    Β·

    To store keywords and locations as comma-separated values in a single cell when using the "write to table" feature, follow these steps: 1. Use the Extract Data From Values function to process your data. 2. Add a new column using the Forward Slash (/) command. 3. Apply a custom extraction Regex: [^,"]+"?[^,"]+ This will split the values into a list. Then, when sending the data to the new table, you can use a join function to combine the list items into a comma-separated string within a single cell. If you're still having issues, try using a different separator like a pipe (|) or semicolon (;) within your cells, and enclose the entire cell content in double quotes to prevent unintended splitting.

  • Avatar of Channeled
    Channeled
    APP
    Β·
    Β·