.png){kind=logo}
Updating Existing Columns in an Enriched Profile: Best Practices
If I have a enriched profile and would like to push info into existing columns, can I update it directly? Or do I need to create a new column for new info first?
You can do either - you have two options: 1. Map directly to existing columns: You can push new enrichment data into existing columns. To do this: ā¢ Click on the enrichment cell containing the data you want to use ā¢ In the Cell details panel, hover over the desired endpoint ā¢ Click 'Add as column' ā¢ Under "Map to an existing column", select your destination column ā¢ Note that this will overwrite existing values in the destination column. 2. Create new columns: Alternatively, you can create new separate columns: ā¢ Click on the enrichment cell with your data ā¢ Hover over the endpoint you want to use ā¢ Click 'Add as column' ā¢ Enter a column description ā¢ Click 'Create column' Source: Table columns overview | Documentation | Clay University
Andi D.Ā·Ā·I did that as shown in the screenshot, but new data aren't showing in my existing columns
This could be happening because the data needs to be refreshed or updated. Here are a few things to check: 1. The data may be on a refresh schedule - by default, updates happen every 24 hours. 2. Fields with null values are ignored during updates to prevent overwriting existing data. Make sure your source data contains valid values.To manually trigger an update, you can click on the enrichment column header and select sources to refresh the data.If the issue persists after trying these steps, you may want to request help from a human agent who can take a closer look at your specific setup. Source: Snowflake integration overview | Documentation | Clay University
Looks like you're still looking for help. We're escalating this over to our support team and someone should be in touch soon. In the meantime, feel free to include any other information that may be helpful in solving your issue!
Bo (.Ā·Ā·Hey, thanks for reaching out - I'd create a new merge column 1. Go to the far left of the table and click on Add Column 2. Select Merge 3. Link the value you want using the forward slash (/) first, then link the second value, etc. using the forward slash again! Let me know if that helps! :)
- Andi D.Ā·Ā·
Absolutely, Bo. So Grouped Columns cannot be pushed to existing column?
- Bo (.Ā·Ā·
If that column is empty, yes, otherwise no, it'll overwrite the current data for the newly linked value, not the older one!
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.
- Andi D.Ā·Ā·
Thanks Bo! Might be a bug then? As shown in the screenshow, I was trying to move the data into existing columns where cells are indeed empty. It says "updating" but then nothing happens Pushing it into a entirely new column works fine though