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
Solved! Go to 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
@JagdeeshN thank you that makes a lot of sense; appreciate the quick response as well!