Workflow with multiple options sometimes one will be empty

Question

Hi Team

Wanted to ask for some help. I have an alteryx model that reconciles 2 sets of data independently from a single client, sometimes they will need both to be reconciled but sometimes only the one path will have data. When I run it without data in the one path I keep getting an error saying that a filter cannot be null. Is there a way around the error to make it still run without having to turn anything into a macro to add the detour tool on?

Thanks
Elena

JagdeeshN · Accepted Answer

Hi @ElzNicola ,

You can possible use the COUNT RECORDS tool to handle this error. This would give you a number to check even if there are no records.

Please find attached a sample workflow.

Best,

Jagdeesh