The model verify has many options, including the following:
Filter produces at least one row: assign a filter which will return a row
Filter produces no rows: assign a filter which will not return a row
Modify your model:
Add a formula field, call this field RecCount, make it numeric field, and assign this function: recno()
Add a filter and name it RecCountGTzero, and assign this expression: RecCount=1
In the following Visual Process there are two jobs (two models, and two model verifies)
Configure the model verify for each job, check Filter produces at least one row, and assign the RecCountGTzero filter (per screenshot below).
If the first job does not create a row, the export will be skipped and the process continue with the second job. This example is for two jobs, but you can add more jobs for different models.
Thanks for the help. I was able to get it to skip by using the 'Unfiltered table has at least one row' option'.
But now the issue is that when the verify fails it says 'some inputs are not verified' and then the export says 'there are no inputs to process. export will be skipped'. The issue is we have a global alert set up for visual processes that we will be sent an email each time it skips the export, is this always the case that an email will be sent when an export skipped? There is an input that the verify model just used, so this warning saying that there is no input to process is misleading to the alert.
Thanks again Mo
I can see your point, unfortunately the SystemAlertNoInputToExporter will be raised when the verify model fails, and when it fails it causes the following message:
There are no inputs to process. Export will be skipped. I will discuss this in our next Automator meeting with the product manager.
If you need an email to be generated when the verify model fails , you can add an email distribution and connected to the Verify model (on the visual process canvas, right click and select Show Advanced connectors). You should see red colored chevron. Connect the verify model to the email distribution. When verify model fails, an email will be generated.