Workflow with multiple options sometimes one will be empty

[ElzNicola]

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 solution]

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

[ElzNicola]

@JagdeeshN thank you that makes a lot of sense; appreciate the quick response as well!