Identifying Values in Nested Arrays Using Formulas

Andreas Wernicke · 2025-01-28 18:55:40.853333+00

How can I have a formula look into an array to identify a value? This formula doesn’t catch values that are nested, for example in the HG insights results.

Identifying Values in Nested Arrays Using Formulas | Clay

8 comments

· Sorted by Oldest

Andreas Wernicke
·
·
https://app.clay.com/workspaces/439843/tables/t_UtqFZKF8SJ6C/views/gv_KUu3R8YZ333F
Channeled
APP
·
·
You can use AI formulas to extract and analyze nested values in your data. Here's how to do it: 1. Click on the column options 2. Select "Ask question about items with AI" 3. Choose the formula option 4. Write a clear prompt describing what you want to extract or analyze from the nested dataThe AI will generate the appropriate code to extract the specific insights you need from nested arrays. This approach works for various data types including counting experiences, concatenating values, or analyzing specific fields within nested structures.Remember that experimentation is key - try different prompts and adjust your formulas to get exactly the information you need from your nested data. Sources: AI Formulas + Conditional Runs [CRM Enrichment] - Clay University AI Formulas + Conditional Runs [Clay 101] - Clay University
Andreas Wernicke
·
·
doesn’t catch nested results, only the ones that are spelled out in the PredictLeads results
Andreas Wernicke
·
·
Channeled
APP
·
·
To extract nested values from PredictLeads results, you can use Clay's AI formulas feature. Here's how: 1. Click on the column options 2. Select "Ask question about items with AI" 3. Use the formula option 4. Write a specific prompt that describes exactly what you want to extract from the nested PredictLeads dataFor example, if you want to extract specific fields or count certain values within the nested structure, clearly describe this in your prompt. The AI will generate the appropriate code to access those nested values.Remember that you may need to experiment with different prompts to get exactly what you need. If the first attempt doesn't give you the desired results, try adjusting your prompt or modifying the generated code until you get the right output. Sources: AI Formulas + Conditional Runs [Clay 101] - Clay University AI Formulas + Conditional Runs [Automated Outbound] - Clay University
Channeled
APP
·
·
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!
Mark (Clay)
·
·
I'd suggest being more explicit about where the relevant values can be found. Testing with a prompt like...
If any of [technologiesFound], the technology name in [data], or the product_name of the [products] contain etc.
...got a bit of incremental improvement. I didn't want to interfere with your existing column, but dropped the formula into a new one at the end of the table.
Channeled
APP
·
·
Hi Andreas Wernicke! This thread was recently closed by our Support team. If you have a moment, please share your feedback:

Andreas Wernicke
·
·
https://app.clay.com/workspaces/439843/tables/t_UtqFZKF8SJ6C/views/gv_KUu3R8YZ333F
Channeled
APP
·
·
You can use AI formulas to extract and analyze nested values in your data. Here's how to do it: 1. Click on the column options 2. Select "Ask question about items with AI" 3. Choose the formula option 4. Write a clear prompt describing what you want to extract or analyze from the nested dataThe AI will generate the appropriate code to extract the specific insights you need from nested arrays. This approach works for various data types including counting experiences, concatenating values, or analyzing specific fields within nested structures.Remember that experimentation is key - try different prompts and adjust your formulas to get exactly the information you need from your nested data. Sources: AI Formulas + Conditional Runs [CRM Enrichment] - Clay University AI Formulas + Conditional Runs [Clay 101] - Clay University
Andreas Wernicke
·
·
doesn’t catch nested results, only the ones that are spelled out in the PredictLeads results
Andreas Wernicke
·
·
Channeled
APP
·
·
To extract nested values from PredictLeads results, you can use Clay's AI formulas feature. Here's how: 1. Click on the column options 2. Select "Ask question about items with AI" 3. Use the formula option 4. Write a specific prompt that describes exactly what you want to extract from the nested PredictLeads dataFor example, if you want to extract specific fields or count certain values within the nested structure, clearly describe this in your prompt. The AI will generate the appropriate code to access those nested values.Remember that you may need to experiment with different prompts to get exactly what you need. If the first attempt doesn't give you the desired results, try adjusting your prompt or modifying the generated code until you get the right output. Sources: AI Formulas + Conditional Runs [Clay 101] - Clay University AI Formulas + Conditional Runs [Automated Outbound] - Clay University
Channeled
APP
·
·
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!
Mark (Clay)
·
·
I'd suggest being more explicit about where the relevant values can be found. Testing with a prompt like...
If any of [technologiesFound], the technology name in [data], or the product_name of the [products] contain etc.
...got a bit of incremental improvement. I didn't want to interfere with your existing column, but dropped the formula into a new one at the end of the table.
Channeled
APP
·
·
Hi Andreas Wernicke! This thread was recently closed by our Support team. If you have a moment, please share your feedback: