SOLVED
Error in dynamic input
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
Khanzali007
8 - Asteroid
07-05-2022
11:26 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi,
What does this error means, I have already selected the sheet name refer second screen shot. Please help
Solved! Go to Solution.
Labels:
2 REPLIES 2
MatthewO
Alteryx Alumni (Retired)
07-05-2022
11:53 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@Khanzali007 when you configure the Dynamic Input tool, you are configuring a "template". However, the template configuration gets replaced with the incoming dynamic data. Because you selected to "Change Entire File Path", the sheet name in the configuration is removed. You can append a sheet name to the incoming data in the following format.
C:\ExamplePath...\MyExcelFile.xlsx|||Sheet1
DataNath
17 - Castor
07-05-2022
11:54 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@Khanzali007 as you’re using the full path for dynamic input, I believe you need to have the sheet name also specified in the full filepath. Your path ends in .xlsx but should end in something like .xlsx|||<SheetName>