Home
Events
Groups
Members

00 Clay Announcements
01 Community General
01 Props and Wins
01 Watercooler
01 Welcome and Intros
02 Bugs
02 Starting with Clay
02 Support
03 Feedback & Requests
03 Tutorials & Inspiration
04 FT Job Opps
Gtm Career Advice
Member Spotlight

Community Guidelines

Powered by Tightknit

Data Extraction Issues with Joinedmatches Column for Nordbaby

·

·

Trying to the pass column Joinedmatches data to a new column, some data are not being passed to clean column (text extraction) take the example of the company Nordbaby highlighted

Loading attachments

Data Extraction Issues with Joinedmatches Column for Nordbaby | Clay

5 comments

· Sorted by Oldest

Carlos Lopez
·
·
Workspace : https://app.clay.com/workspaces/279801/tables/t_6CKv4hA8QDPX/views/gv_hCGvFjKU95gX
Channeled
APP
·
·
💤 You've caught us outside of our support hours (9am-9pm EST), but don't worry - we'll be back in touch within 24 hours (often sooner!). If you haven't already, please include the URL of your table in the thread below so that we can help you as quickly as possible!
Daniela Debebs (Clay)
·
·
Hey! Thanks for reaching out. Happy to help. The reason why some cells are failing to populate is because the inputs don't match the column type. The column type is set to "email" but some cells are populated with multiple emails or website urls. That's why they currently have an error and failed to populate in the "Text extraction" column. The workaround for this is changing the column type to text (see screenshot below) before extracting. That should resolve the error. You can also set it to only extract one email (for cells that include email values) by instructing it to "Extract the first email value in {{JoinedMatches}}" in the formula generator. Let me know if this helps. https://downloads.intercomcdn.com/i/o/1173911313/9a3b87591e4a6d18166d90f1/CleanShot+2024-09-09+at+15_54_49%402x.png?expires=1725895800&signature=c9f6141cfe0aaffbb689719fd5ee8eae796094bbe465821a523b99ff94f8f005&req=dSEgFcB%2FnIJeWvMW1HO4zZDxkUJCxSWwj4Yhrj5c7hTQ9SmGh1ahHuk7uKpl%0A9Y8s%0A
Carlos Lopez
·
·
Thanks Daniela, all solved
Channeled
APP
·
·
Hi Carlos Lopez! This thread was recently closed by our Support team. If you have a moment, please share your feedback: