This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
I have to run a number of checks on a large set of data. One check is to see if there is at least on record for each contract number in a key. My thought was to join them with the document on the left and the key on the right. Then, count the results in the left join. If the count is 0, then it passes. However, I am getting no results. I have attached a simple example of what i am talking about. I know I can just look and see if it's empty, but I have about 50 checks and am trying to create a report of Passes and fails.
I think the best tools for this scenario are Count Record (coincidentally this is your user icon) and Test. The Count Records will always produce a record with the count of records, and that value can be used by the Test tool to throw an error if the count is not 0.
I've added these tools to your workflow. Take a look and let me know if this works for you.