Input sheet is blank or missing

[Dhilip_Kumar]

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.

[Prometheus]

@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. 

[Dhilip_Kumar]

Yes. How could I overcome this issue.