Read multiple files and multiple sheets within those files in one flow

Question

Suppose I have files Sales_week1.xlsx, Sales_week2.xlsx and each file has sheets day1, day 2 etc.

How can I read all daily sales in one table?

I am looking to use Intput, Directory and Dynamic input tools

grazitti_sapna · Answer

@vikaschandra1993  You can achieve this by using below workflow. Let me know if it helped.

Thanks!!

Multiple_Sheets.yxzp

ChrisTX · Answer

See if this knowledge base article helps

The Ultimate Input Data Flowchart
Community > Designer > Designer Knowledge > The Ultimate Input Data Flowchart
https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/The-Ultimate-Input-Data-Flowchart/ta-p/20480

Qiu · Answer

@vikaschandra1993 
Check this out.
https://community.alteryx.com/t5/Public-Community-Gallery/Import-Multiple-Excel-Workbooks-amp-Multiple-Sheets/ta-p/996552