Hello Community,
I am struggling to design a dynamic Import of one sheet from the latest version of an excel workbook updated in daily basis.
An error message asking to specify a sheet while I select it in the template file in the Dynamic input tool
Does someone faced this issue in the past or has a solution please?
Regards
Hi @Ouss
You can give this blog a try.
http://community.alteryx.com/t5/Alteryx-Knowledge-Base/The-Ultimate-Input-Data-Flowchart/ta-p/20480
Another way would be manual set the sheets names.
Use an append tool to add sheetnames and use formula tool to add sheetnames to the path.
Hope this helps🙂