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

[vikaschandra1993]

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 

[Qiu]

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

[ChrisTX]

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/t...

[grazitti_sapna]

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

Thanks!!