Question for importing multiple tabs in one Excel

[gongyunqian622]

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!

[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?

[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/4536...

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

[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-Fil...