Identify sheet names in multiple excel files
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
hi,
I have multiple excel files with differently named multiple excel sheets inside them. How can i use Alteryx to identify all the excel files with the set criteria sheet names?
- Labels:
- Data Investigation
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
You can use the Input Data tool to read in the excel file, but instead of reading in a specific sheet you can select "Import only list of sheet names"!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Thank you Alex for your quick assistance.
Your approach is listing out all the sheet names but is there a way to get the file name also along with the sheet names? And then read the excel sheets which meets the set criteria.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Yes - in the same input data, you have the option to "Output File Name as Field"!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
hi, is there a way to do this with the directory tool and without the batch macro?
thanks-
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
i ended up using a solution from another thread. formula between directory input and dynamic input:
[FilePath] + "|||<List of Sheet Names>"
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
That's correct - you can do Directory --> Formula to add <List of Sheet names> --> Dynamic Input to get this list --> Formula to replace <List of Sheet Names> with actual sheets --> Dynamic Input to read in sheets