Expected Result when Running Look Up Record in Another Clay Table

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?

8 comments

Brandon C.
·
·
Hey Ian M.! 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 C.
·
·
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 M.
·
·
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 Q.
·
·
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 Q.
·
·
What are you trying to do here though?
Matthew Q.
·
·
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”