Workflow - If input file is blank

[gavinloi]

Hi All,

I am facing an issue whereby the alteryx reads the input file on a daily basis and it has formulas that passes through it. However I realized that if for a particular day, the excel is empty, a Parse error would occur as there is nothing for the formula to read. Can i check is there a way to bypass the formulas in this case or would there be a walk around ?

Thank you!

My workflow looks something like this but it only runs if the "Test - data" is the input file as it has values in it.

Yours Sincerely,

Gavin

[binay2448 · Accepted solution]

Hi @gavinloi ,

You can use Filter tool in between ....

Find attached example... 

[gavinloi]

@binay2448 Beautiful, it works! 🙂 Thank you so much!