The Inspire Pin contest has begun! Win a free pass to Inspire by submitting your design to be made into a real-life pin! Submission details can be found here.

community Alteryx Academy MyAlteryx
alteryx Community
Search
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Close
Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Input sheet is blank or missing

Dhilip_Kumar
8 - Asteroid
‎09-21-2023 06:49 AM

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
Reply
0 Likes
2 REPLIES 2
Prometheus
12 - Quasar
‎09-21-2023 08:19 AM

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

Reply
0 Likes
Dhilip_Kumar
8 - Asteroid
‎09-21-2023 09:42 AM

Yes. How could I overcome this issue.

Reply
0 Likes
Community Live building your first workflow
Labels