Expected Result when Running Look Up Record in Another Clay Table

Ian Mckee · 2024-01-08 10:53:20.515335+00

Look Up Record in Another Clay Table When I run this I was kinda expecting that Success would = True if it ran and = False if it did not This would allow me to tell the difference between a look up that Ran successfully and did not find any matching records and a look up that did not run - in which case the lack of a result does not mean there are no matches How do I manage this?

Expected Result when Running Look Up Record in Another Clay Table | Clay

8 comments

· Sorted by Oldest

Brandon Charleson
·
·
Hey Ian Mckee! You’re correct, when you run the Look Up From Another table it’ll show Success = true or false. From there, I would use a Filter or Formula column to manage what you want to do with the matched records (such as to run a formula to not enrich the matched records).
✨1
Brandon Charleson
·
·
As a best practice, (depending on the data), you may want to run more than one Lookup record for different columns in order to comb through and refine the two tables. Hope that helps!
✨1
Clay Team
APP
·
·
To add to what Brandon mentioned and address the "if it ran or not" part of it, just like any other enrichment, it will let you know if data/results were found or not just like in your screenshot which means that the row ran. If it's blank or has another text or error-like message similar to the "missing input" from the pic, that would mean it didn't run
:arc:1
Clay Team
APP
·
·
In any case, you can apply filters based on those that have some form of result or indicator that it ran to surface those that haven't run if that's what you need. For example, if you extract the Success column, you apply a filter and show only those that are empty, which would mean they didn't run, instead of filtering for "true" or "false", which in that case means it ran regardless if it returned other data or not.
Ian Mckee
·
·
Maybe I am doing something wrong, because it seems that when it does not run, success is not FALSE What do I test for to determine if it ran or not?
Matthew Quan (Clay)
·
·
If it did not run, success would not be evaluated. The variable is named confusingly. But we don’t currently support evaluating based on the column having run or not.
Matthew Quan (Clay)
·
·
What are you trying to do here though?
Matthew Quan (Clay)
·
·
If you’re just trying to see if it will result in missing input - you can make a checkbox column as well to toggle on whenever the input is empty which will also signify what you wanted as “False”

Brandon Charleson
·
·
Hey Ian Mckee! You’re correct, when you run the Look Up From Another table it’ll show Success = true or false. From there, I would use a Filter or Formula column to manage what you want to do with the matched records (such as to run a formula to not enrich the matched records).
✨1
Brandon Charleson
·
·
As a best practice, (depending on the data), you may want to run more than one Lookup record for different columns in order to comb through and refine the two tables. Hope that helps!
✨1
Clay Team
APP
·
·
To add to what Brandon mentioned and address the "if it ran or not" part of it, just like any other enrichment, it will let you know if data/results were found or not just like in your screenshot which means that the row ran. If it's blank or has another text or error-like message similar to the "missing input" from the pic, that would mean it didn't run
:arc:1
Clay Team
APP
·
·
In any case, you can apply filters based on those that have some form of result or indicator that it ran to surface those that haven't run if that's what you need. For example, if you extract the Success column, you apply a filter and show only those that are empty, which would mean they didn't run, instead of filtering for "true" or "false", which in that case means it ran regardless if it returned other data or not.
Ian Mckee
·
·
Maybe I am doing something wrong, because it seems that when it does not run, success is not FALSE What do I test for to determine if it ran or not?
Matthew Quan (Clay)
·
·
If it did not run, success would not be evaluated. The variable is named confusingly. But we don’t currently support evaluating based on the column having run or not.
Matthew Quan (Clay)
·
·
What are you trying to do here though?
Matthew Quan (Clay)
·
·
If you’re just trying to see if it will result in missing input - you can make a checkbox column as well to toggle on whenever the input is empty which will also signify what you wanted as “False”