Input sheet is blank or missing

Question

Hi,

On my input files i have three sheets named Sales, Purchase and Pending, Some times i got blank data  on anyone of the tabs or sheet not given, that time i got error while running the workflow. I have attached my workflow and different types of input files for your reference. please help me to get desired result.

Type 1: All three sheets have data

Type 2: Anyone of the sheet has no data

Type 3: sheet is missing on the input file.

Type 3.xlsx

Type 2.xlsx

Type 1.xlsx

Test Workflow.yxwz

Dhilip_Kumar · Answer

Yes. How could I overcome this issue.

Prometheus · Answer

@Dhilip_Kumar If your Input Data tool is looking for the sheet named "Pending" and it doesn't exist, you're going to get an error.