Any help would be greatly appreciated. I have this on other workflows and even in the workflow I'm using but getting this error on one file input.
I have set my directly tool. I have all input files in this directory so I have filtered for the file name as "contains" xxx as the files always start with xxx and the date they were run. The filter tool output is the file for the file I'm looking for. At this point I'm good. The file typically contains multiple sheets. I've added the Dynamic Input tool here, selected the path, selected list of sheet Names. They show in the preview, but when I run the workflow regardless of what options I select in the read a list of data sources I get errors that I must choose a sheet or that the sheet does not exist.
the file is not corrupted, I can open it. It works if I select the file directly and do not use the directory and dynamic input, but I want to schedule so I need this in the future.
What am I doing wrong (as it works with all the other inputs) or what can I do differently to avoid this?
