Troubleshooting Errors in Clay Workspace Tables and Data Entry Issues

Justine G. · 2025-01-07T06:09:22.908182+00:00

Hello there, I have a few problems: • In this table (link: Clay Workspace ), I encounter the errors "Missing Inputs" and "Herausforderung Branche > Beispiele > 0 is blank" in the column titled "Herausforderung Branche_kritischer_punkt." However, 0* is not blank and does have a result. Please see rows 179, 180, etc. Why is this happening and how can I solve this? • In the same table, the column "Lookup Single Row in Other Table" field is sometimes blank, e.g., in row 174. I understand that the field is blank because there is no corresponding entry in the referencing row of the looked-up table (link: Looked-Up Table ). However, in this table (Sheet 1), I have a *run condition on the column "Write to other table" that should prevent the data from being pushed into the next sheet when it says "Run condition not met." So where is this data entry in Sheet 3 coming from?

Justine G.

Hello there, I have a few problems:

In this table (link: Clay Workspace), I encounter the errors "Missing Inputs" and "Herausforderung Branche > Beispiele > 0 is blank" in the column titled "Herausforderung Branche_kritischer_punkt." However, 0 is not blank and does have a result. Please see rows 179, 180, etc. Why is this happening and how can I solve this?

In the same table, the column "Lookup Single Row in Other Table" field is sometimes blank, e.g., in row 174. I understand that the field is blank because there is no corresponding entry in the referencing row of the looked-up table (link: Looked-Up Table). However, in this table (Sheet 1), I have a run condition on the column "Write to other table" that should prevent the data from being pushed into the next sheet when it says "Run condition not met." So where is this data entry in Sheet 3 coming from?

17 comments

Channeled
APP
·
·
The "Lookup Single Row in Other Table" field is designed to check for the existence of specific data across different tables in your Clay workspace. If this field is blank, it means that no matching row was found in the referenced table.Regarding the run condition, it's important to understand that conditional runs work like if-else statements - they only control whether an enrichment or action runs, not the results of the lookup itself.The run condition on your "Write to other table" column controls when data gets pushed to the next sheet, but it doesn't affect the lookup functionality. The lookup will still attempt to find matching data regardless of the run condition, and if no matching data exists, the field will remain blank. Sources: Lookup Single Row in Other Table with Clay Find People [Clay 101] - Clay University Conditional runs | Documentation | 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!
Daniel K.
·
·
Hey there, happy to help! 1. You need to rerun the column "research_n8n" on errors. Then the error "missing inputs" should disappear. https://downloads.intercomcdn.com/i/o/w28k1kwz/1324149350/ab300596504f2808277b27d35631/Arc_LXroooOT9f.png?expires=1736244900&signature=36dcb67a4b3c5d991eabdd4eb8aeaf29f64fcda8454d763477a19fa6450e9c31&req=dSMlEsh6lIJaWfMW1HO4zXMDXAzu9ULiWddOKD%2F6cpaP%2FIRiHiWMXDIXVEFB%0AKPPP%0A 2. It seems all rows have results. Of course, if the issue persists, happy to dive deeper here :) https://downloads.intercomcdn.com/i/o/w28k1kwz/1324156106/d925ce1dd4f27488c237d225c255/Arc_0NzDgzreLA.png?expires=1736244900&signature=ee8182d13cb0f7c21cc632483536572af916295bbe0d9610225393e4c4397958&req=dSMlEsh7m4BfX%2FMW1HO4zX%2B3MvBeCd9En0KYJI4G9oDnpIc%2Fks3vL%2BHcGxuC%0AmiQr%0A If there's anything else I can assist you with, please let me know! 😊 Have a great Tuesday, Daniel
Justine G.
·
·
Hey, thanks for the response! 2. I think I misspoke: Lookup has results, but the row "Aufgabe 1" etc. is sometimes blank. Aufgabe 1 is a column from the lookup. So for example in row 174 I understand that the field is blank because there is no corresponding entry in the referencing row of the looked-up table (link: Looked-Up Table). However, in this table (Sheet 1), I have a run condition on the column "Write to other table" that should prevent the data from being pushed into the next sheet when it says "Run condition not met." So where is this data entry in Sheet 3 coming from?
Justine G.
·
·
Also, I understand now why I get the error "missing inputs". But why do I encounter the error "Herausforderung Branche > Beispiele > 0 is blank" in the column titled "Herausforderung Branche_kritischer_punkt." However, 0 is not blank and does have a result?
Daniel K.
·
·
Hey! 1. If you apply the error filter on "Herausforderung Branche_kritischer_punkt.", you can see there are no errors except the "missing inputs". If you refer to a specific AI output, can you refer me to the row? If the 0 is related to an output, can you re-run the specific row? If it helps, feel free to shoot over a short loom. 2. Can you help me specify what you mean with sheet1, 2 and 3. That helps me to understand the relationships of the data you're pushing between the different tables. Generally, I recommend to keep related tables within a workbook to quicker switch between them.
Justine G.
·
·
Daniel K. https://www.loom.com/share/10d5b8bc70ef483a834ce238956a870f?sid=4e937ef8-8bfd-410b-92ad-807558e25f7d Sorry, English is not my first language 😄
Daniel K.
·
·
But your English for sure sounds like you're fluent in it :) Here's my video: https://www.loom.com/share/ea3be1f6f75c461197ee6cdbf50f241e Liebe Grüße, Daniel
Justine G.
·
·
Thank you very much! That helped and explained it very well 🙂 I do have one more question, since you are already kinda familiar with the sheets now. In this Sheet: https://app.clay.com/workspaces/257542/tables/t_49kzmuEdY428/views/gv_X9yv7gVwnx7r Why is the column "lead_UA_kernprozesse" sometimes empty and how can I fix it (without having to manually enter the sheet and rerun it)?
Daniel K.
·
·
Glad it was useful :) It looks like the issue is caused by stale data. Stale data is when the output of an integration column is no longer considered up to date because the input that was used to run that column was changed. You can find stale data by double-clicking on the rows that are not running, and you’ll see a menu showing up. Here’s an example of identifying stale or outdated data: Stale Data Example https://downloads.intercomcdn.com/i/o/1125019413/c53037e58cb9aac03f8bc3c7/CleanShot+2024-07-25+at+_41oGsvnf1J%402x.png?expires=1736260200&signature=d1685843baeb380610a23fc6a7f7d2af6b365e1d401c9653f7e8c970cdf32ac2&req=dSElE8l%2FlIVeWvMW1HO4zQWamjJ%2FohsBJXU7dljde4OyoA%3D%3D%0A
Justine G.
·
·
Thank you, I have seen this video before, but I am not sure how to fix my issue, because my table is on auto update and I can not see any stale data in this sheet. I even added a runcondition for the column to only run, if the dependencies have a result Do you know how to fix it in this specific circumstance?
Daniel K.
·
·
Hey, you can filter for stale data and only run those rows. Once done, you can remove the filter again :) Let me know how it goes :) https://downloads.intercomcdn.com/i/o/w28k1kwz/1324537281/3505cc5b0a55c9faf2ba06dc0b74/Arc_nsj84FXHjc.png?expires=1736261100&signature=158a5d26e9c1c0670e3dfcf9331bf34ef6c0801a65efd92803d050d83ba21427&req=dSMlEsx9moNXWPMW1HO4zfu%2B%2Bp20eAU4dzxuz3jCdougm8qd2AmuN%2B6C6l9O%0AfHwW%0A
Justine G.
·
·
Daniel K. https://www.loom.com/share/40523cfa61514b43a95ef56698be768e?sid=71f58e47-b596-49ca-8a49-22b81f0f054c
Daniela D.
·
·
Hey Justine! Thanks for sharing. Happy to help✨. It looks like the issue is related to a delay with specific inputs (required by the AI integration) populating in the table. This likely is due to the Lookup integration not running for some cells as quickly as other cells are populated. That is, the AI integration column was triggered to run before that value (Aufgabe_4) was returned. To confirm, was the conditional formula added after you noticed that some cells had not run?
Justine G.
·
·
Daniela D. I assumed this would be the issue as well, which is why I deleted all rows and added the runcondition before asking for help. The runcondition should prevent the column from running, until all dependent columns have an entry. But even after entering the runcondition, the issue persists: if you check row 1291 (data entry was created today on the 09.01.), the issue is still happening even though the runcondition is active. So I am still clueless as to what I can do to prevent this error
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
·
·
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.