Get data from the Excel sheets based on conditon (Using Sheet Names)

[munipavankumar]

Hello,

I'm working with an input Excel file named 'Car Sales Category' that contains multiple sheets labeled from 2000 to 2022. Each sheet requires different cleansing steps means the Header Names are different. We deal with various categories such as Bikes, Soaps, and Shampoo, all sharing the same sheet names and requiring identical cleansing processes. However, to work on a different category, I have to manually select over 20+ sheets and run the workflow, which is time-consuming. Help me to build workflow. Thanks.

----------------------------------------------------------------------------------------------------------------------------------------------------------------------------

----------------------------------------------------------------------------------------------------------------------------------------------------------------------------

[CoG]

The Workflow you have currently is a great start, assuming every sheet really requires totally different processing. The only thing you would need to add is the Dynamic Input Tool to then pull relevant data from the sheets.

If the processing is similar across sheets and it's just that you need to keep track of which sheet you are dealing with, then I recommend building a Batch Macro to handle the Dynamic Input of each sheet.

Here is a helpful knowledge article for Dynamic Input Tool: https://knowledge.alteryx.com/index/s/article/How-To-Import-Multiple-Excel-Sheets-or-a-Specific-Exce...

Happy Solving!!!

[binuacs]

@munipavankumar try batch macro in your use case.

https://knowledge.alteryx.com/index/s/article/The-Ultimate-Input-Data-Flowchart-1583459854309

Inside the macro, you can apply filters based on the sheet name