Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
Start Free Trial

Alteryx Designer Desktop Discussions

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

Input file missing or input file has blank data

Dhilip_Kumar
8 - Asteroid

1. Sometimes we receive input file with no data or some of the tabs are missing, in that case we got below error message.

Dhilip_Kumar_0-1692608400809.png

Please help me to avoid these errors. Thanks in advance!!!

 

2. Header start in dynamic rows, sometimes it may starts row 4, sometimes it may start row 7. in this case how can we find the exact row to start import our data. I have attached example file. Please do the needful.

 

FYI, Header name "ssn" and we need import data from there.

3 REPLIES 3
binuacs
21 - Polaris

@Dhilip_Kumar One way of doing this

image.png

ChrisTX
16 - Nebula
16 - Nebula

This post includes a workflow to identify expected Sheets: https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Catch-and-log-which-Excel-sheets-were-...

 

Chris

Dhilip_Kumar
8 - Asteroid

I got error on below workflow if the sheet is blank. Please do the needful.

Labels
Top Solution Authors