How to Import/split Excel into multiple sheets all at once with condition using Alteryx

[munipavankumar]

For example I have one excel file named Sales. It has multiple sheets called 2000, 2001, upto 2022 irrespective of data. After that I need to do some other ETL process for each year. How we can do automation for selecting the sheets as condition year. Please help. Thanks.

[AndrewDMerrill · Accepted solution]

You will want to use the Dynamic Input Tool to get separate sheets into workflow. Depending on the kind of ETL processes that you need to run for each year, you may or may not need to use a batch macro, batched by year/sheet.

With more information, a more specific answer can be given for your use case.

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

Happy Solving!!!