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?
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.
.png)