Error in dynamic input

[Khanzali007]

Hi,

What does this error means, I have already selected the sheet name refer second screen shot. Please help

[MatthewO · Accepted solution]

@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 · Accepted solution]

@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>