Hi team,
I have an excel file with some worksheets, so, only some worksheets have the same schema. I would like to import only worksheets with the same schema.
I was thinking to create a text file and include the name of the worksheets that have the same schema, and after that to do a filter in the excel file. Is it possible, do you have another way to do that? Could you help me, please?
I've got the all worksheet's names:
Rgds
Eduardo
Solved! Go to Solution.
You might find this macro helpful: https://community.alteryx.com/t5/Engine-Works/The-Ultimate-Alteryx-Holiday-gift-of-2015-Read-ALL-Exc...
It allows you to point at a directory and bring in as many sheets as you want from the Excel files regardless of schema. You can add additional logic if desired.