Hi,
I need to add a validation/test/exception report to one of my processes. This test is to compare 2 tables and test if there is a new record for the current month in the first table, there needs to be an associated record in the 2nd table. In some months, there might not be a record in either table, therefore, my process is resulting in "No Records".
I would like to determine if there is a way to to complete this test (which I have already done) and based on the results generate one of 2 reports:
- If there are current month records in the first table, populate the table that will show be the results of the test for the current month records.
- If there are no current month records (table result s in "No Records"), populate a report that would show "No Exceptions"
The issue that I am having is if there are no records, the table and report will no generate. I have tried to add a blank row, which then in turn works, but will run even when I have current month records, therefore, it is generating both reports and I only want one.
Is there a way to do an filter to choose which report to run? I have attached my sample workflow for what I am attempting, but am hitting a wall.
Thanks!
