Question for importing multiple tabs in one Excel

Hi,

I have 69 tabs in one excel and they are in the same format. I used Input tool and choose to import list of sheet names. And then I used dynamic input tool and also chose sheet names. However, after I ran the workflow, it showed No data available. Does anyone know how to fix it?

Thank you!

Bug

Accepted answers

All comments

Qiu

@gongyunqian622
Can you give a snapshot on the configuraton of Dynamic Input tool?

gongyunqian622

Thank you!

Qiu

@gongyunqian622
Its then strange, since I ran a test and its just working.

I do notice that there is a message saying "ended by downstream tool"?

Do you have any tools placed after the Dynamic input?

0311-gongyunqian622.yxzp

gongyunqian622

Yes... It is very wired. I only have input and dynamic tool... I did not have anything after.

Qiu

@gongyunqian622
I found this post that might help.

Please try to add a Browse Tool after the Dynamic Tool?

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Ended-by-downstream-workflow/td-p/45369

gongyunqian622

It shows error now.

Qiu

@gongyunqian622
The error indicates that your data format (schema) is different among tabs, so your statement "they are in the same format. " may not be valid.

If that is the case, you might want to use this macro I downloaded from here.

Multi Sheet Import Example.yxzp

gongyunqian622

I cannot open the file you gave me. It said I am not using the most updated version of alteryx. I am using 2019.3.1 version

Qiu

@gongyunqian622

Try to follow the instruction below, sorry the snashots are gone though.

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/How-to-downgrade-packaged-workflow-File-types-yxzp/td-p/640288

Quick Links

This months top contributors

FláviaB 262

caltang 177

DanM 167

IraWatt 157

gawa 157