This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
In the capture screenshot want to figure out a way that I could better accommodate the adjustments. Some of the adjustments occur every month but then there are new ones that are not in the green adjustments section that come up and are not programmed for in the workflow so I would have to add any new adjustment as a new input if one should occur. I was trying to figure out if maybe there is a better way or would it be best to create some sort of separate work flow or step that loads up new adjustments in a file and send them to designated columns.
Okay. I think your problem could be solved by using a directory input with a *_Adj.xlsx for the file specification. From there you could use a dynamic input tool and set it up to read the full path. I've attached pictures below. Would this help?
Okay. Sounds good. If your sheet names vary, you can always use the Input Data tool with the wildcard (*). It will then let you select the sheet names, which you can append to your original stream. You can unite the file path with the sheets with a "|||" in a formula tool, and then run through the dynamic input tool to see what you get. I've attached an example below. Because I had multiple sheets, I created a batch macro to capture every sheet on my excel file. Anyway, good luck!