Data Extraction Issues with Joinedmatches Column for Nordbaby | Clay

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

5 comments

Carlos L.
·
·
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 D.
·
·
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 L.
·
·
Thanks Daniela, all solved
Channeled
APP
·
·
Hi Carlos L.! This thread was recently closed by our Support team. If you have a moment, please share your feedback: