Hi,
I'm trying to link to an excel input file in the workflow that not only has a changing file name based on the month pulled, but the tab I need to reference also has a changing name based on the month (for example, file name = PReq September 2019.xlsx, table/tab name = Sept Preq). I've used a wildcard in the file path to take care of the changing file name issue, but I still haven't found a solve to reference the changing table/tab name. Is there a way to easily do this? I've looked into the Dynamic Input tool but am not quite sure how/if this would work in this instance. To add additional info, the table/tab I would need to reference would always include the word "PReq".
Let me know if you need additional info.
