How to Separate Data from One Cell into Multiple Columns

Alex Del ángel · 2025-03-04 02:04:19.821727+00

Guys, good evening. A claygent I did, gave me this result, but it gave me all in one cell. Does anyone know how I could convert each of these brands/results, but each in a different column?

How to Separate Data from One Cell into Multiple Columns | Clay

9 comments

· Sorted by Oldest

Channeled
APP
·
·
When you have enrichment results all in one cell, you can easily split them into separate columns. Here's how: 1. Click on the cell containing your enrichment results to open the Cell details panel on the right 2. Hover over each specific data point (endpoint) you want to separate 3. Click Add as column next to the endpoint you want to extract 4. Enter a description for your new column in the Add description as new column section 5. Click Create column to generate the new column Repeat this process for each data point you want to split into its own column. This will map out the specific endpoints from your parent enrichment column into individual child columns.
Source: Table columns | Documentation | Clay University
Channeled
APP
·
·
Was that helpful?
Alex Del ángel
·
·
So couldn't that be automatic?
Channeled
APP
·
·
Yes, you can automatically split enrichment data into separate columns when setting up your enrichment. Here's how: 1. After configuring your enrichment action, you'll see an option to choose which data fields to display as columns 2. Look for toggle switches next to different data fields (like Emails, Type, Confidence, etc.) 3. Enable the toggle switches for the specific data points you want to appear as separate columns 4. The selected fields will automatically be added as individual columns in your table This way, you can customize your table view and have relevant enrichment results split into separate columns right from the start.
Sources: Run an enrichment | Documentation | Clay University Run an enrichment | Documentation | Clay University
Channeled
APP
·
·
Is that what you were looking for?
1
Channeled
APP
·
·
Looks like you're still looking for help. We're currently outside of our standard office hours (9 AM to 9 PM EST, Monday through Friday), so it may take a little longer for us to respond. If you’re dealing with a specific table, drop the URL below so we can help you quicker. Otherwise, someone from our team will be in touch soon!
Alex Del ángel
·
·
I have a response output with multiple data responses, I don't want all this responses in the same cell.
Stefano (Clay)
·
·
Hi Alex, thank you for reaching out. To split the output of your AI enrichment into different columns with separate pieces of information, follow these steps: First, within the prompt box of your enrichment, you should specify what fields you would like your AI enrichment to return. For example:
(35 kB)
After doing this, scroll down to "Define Outputs". Select "Fields" and then click "Add Output."
(50 kB)
You can rename your outputs to whatever makes sense for your needs. For example, I create a "Date" and "Name of Acquirer" column.
(53 kB)
Once you re-run the process, the two new columns should appear, with the output automatically mapped to them. Please note that if you'd like to change the column type, such as adding a "Number" column, simply click on the "Text" label and select the desired column type from the dropdown menu. Let me know if this helps!
Channeled
APP
·
·
This thread was picked up by our in-app web widget and will no longer sync to Slack. If you are the original poster, you can continue this conversation by logging into https://app.clay.com and clicking "Support" in the sidebar. If you're not the original poster and require help from support, please post in 02 Support.

Channeled
APP
·
·
When you have enrichment results all in one cell, you can easily split them into separate columns. Here's how: 1. Click on the cell containing your enrichment results to open the Cell details panel on the right 2. Hover over each specific data point (endpoint) you want to separate 3. Click Add as column next to the endpoint you want to extract 4. Enter a description for your new column in the Add description as new column section 5. Click Create column to generate the new column Repeat this process for each data point you want to split into its own column. This will map out the specific endpoints from your parent enrichment column into individual child columns.
Source: Table columns | Documentation | Clay University
Channeled
APP
·
·
Was that helpful?
Alex Del ángel
·
·
So couldn't that be automatic?
Channeled
APP
·
·
Yes, you can automatically split enrichment data into separate columns when setting up your enrichment. Here's how: 1. After configuring your enrichment action, you'll see an option to choose which data fields to display as columns 2. Look for toggle switches next to different data fields (like Emails, Type, Confidence, etc.) 3. Enable the toggle switches for the specific data points you want to appear as separate columns 4. The selected fields will automatically be added as individual columns in your table This way, you can customize your table view and have relevant enrichment results split into separate columns right from the start.
Sources: Run an enrichment | Documentation | Clay University Run an enrichment | Documentation | Clay University
Channeled
APP
·
·
Is that what you were looking for?
1
Channeled
APP
·
·
Looks like you're still looking for help. We're currently outside of our standard office hours (9 AM to 9 PM EST, Monday through Friday), so it may take a little longer for us to respond. If you’re dealing with a specific table, drop the URL below so we can help you quicker. Otherwise, someone from our team will be in touch soon!
Alex Del ángel
·
·
I have a response output with multiple data responses, I don't want all this responses in the same cell.
Stefano (Clay)
·
·
Hi Alex, thank you for reaching out. To split the output of your AI enrichment into different columns with separate pieces of information, follow these steps: First, within the prompt box of your enrichment, you should specify what fields you would like your AI enrichment to return. For example:
(35 kB)
After doing this, scroll down to "Define Outputs". Select "Fields" and then click "Add Output."
(50 kB)
You can rename your outputs to whatever makes sense for your needs. For example, I create a "Date" and "Name of Acquirer" column.
(53 kB)
Once you re-run the process, the two new columns should appear, with the output automatically mapped to them. Please note that if you'd like to change the column type, such as adding a "Number" column, simply click on the "Text" label and select the desired column type from the dropdown menu. Let me know if this helps!
Channeled
APP
·
·
This thread was picked up by our in-app web widget and will no longer sync to Slack. If you are the original poster, you can continue this conversation by logging into https://app.clay.com and clicking "Support" in the sidebar. If you're not the original poster and require help from support, please post in 02 Support.