Import one Sheet from latest excel workbook having Multiple sheets

Question

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

messi007 · Answer

@Ouss,

Could you try the attached workflow:

Mise à jour du Média

Regards

ReadFiles.yxzp

atcodedog05 · Answer

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🙂