SOLVED
Specify sheet name in Dynamic Input for reading .xlsx file
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
srk0609
8 - Asteroid
‎12-10-2022
03:41 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
I'm trying to bring top 3 Excel files based on date in file name. Each excel file has multiple sheets. There is sheet with name 'A' in all 3 excel files I want read data in sheet A of all 3 files but getting error 'No sheet specified, you must specify a sheet' in Dynamic Input. Can someone help?
Solved! Go to Solution.
5 REPLIES 5
17 - Castor
‎12-10-2022
03:52 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hey @srk0609, the [FullPath] field from the directory output stops at the filename and therefore doesn't contain the filename. Try making a new calculated field using the following expression, and feed that into the Dynamic Input instead:
[FullPath]+'|||'+'A'
Alteryx
‎12-10-2022
03:59 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
‎12-12-2022
10:47 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Thank you. I'll check and let you know if it worked😊
‎12-12-2022
10:48 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Thank you. I'll check and let you know if it worked😊
‎12-16-2022
10:37 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Thank you so much for the solution
