Troubleshooting Data Transfer Issues Between Tables with AI Enrichment

I have spent nearly all day trying to get data from one table to another and failed. Lets call my tables 1 and 2 in 1 I have an enrichment using AI to find a value yes or no I want to get the results yes/no to table 2 I set up a clay multi row lookup and mapped 2 columns that have a matching data. I see all the columns from table 1 EXCEPT the column I used AI with Do lookups not work if there is AI involved?

9 comments

Channeled
APP
·
·
Clay multi-row lookups should work with AI-enriched columns. To transfer AI-generated yes/no values from one table to another, you can use our "write to table" feature. Here's how: 1. Select your Clay account 2. Choose the destination table 3. Skip list selection by entering "/" 4. Map the columns, including your AI-enriched yes/no column 5. (Optional) Configure auto-update and run conditions If you're still having issues, double-check your column mapping and ensure the AI-enriched column is included. If problems persist, you may need to request human assistance for further troubleshooting.
Sources: Lookup Rows | Documentation | Clay University Write to Other Table | Documentation | Clay University
Mike P.
·
·
1.
what does this mean "Select your Clay account
"
Channeled
APP
·
·
When using our "write to table" feature to transfer AI-enriched data between tables, "Select your Clay account" refers to the first step in the process. This step is necessary to authenticate and access your Clay data. If you haven't set up an account yet, you'll need to obtain your API key to create a Clay integration. This key allows the system to securely access and transfer data between your tables. By selecting your account, you're essentially telling Clay which set of tables and data you want to work with for the transfer operation. This ensures that you're working within your own workspace and data environment.
Sources: Write to Other Table | Documentation | Clay University Write to Other Table | Documentation | Clay University
Mike P.
·
·
This makes no sense, can i talk to a human please
Mike P.
·
·
I've been waiting for help, I'll keep waiting
Owen C.
·
·
Hey Mike, thanks for reaching out and apologies for the delay here. Recording a quick video for ya
Owen C.
·
·
Hey Mike, thanks so much for reaching out, and apologies for the delay here. When using a lookup column, any data that is nested inside a cell won't appear in the results. This means that if you Run an AI column and get a response, you'll need to map that response into its own separate column as a text cell first. Once you've mapped it out into its own cell, re-running the lookup column will successfully pull in that data point. Let me know if this help!
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.
Luke S.
·
·
can you expand on this? i have a company table, with data i create from an aI prompt, that i'm trying to bring to the people table. it's giving me an error message "Please add a valid list here" despite picking at column that's available from a list.