Dynamic Input Issues

[ABD8]

Hi,

I am using an Analytical App with dynamic inputs based on the "list of sheet names".  Whenever I select my new data inputs, the dynamic inputs revert back to the original template file I used to build the workflow. The only way I've found to resolve this is to manually update the input and all dynamic input tools to the new files.

I've used this set up before and have never had these issues. Any help / suggestions greatly appreciated.

Thanks!

Amanda

[lwolfie]

Can you provide a sample workflow or screenshot of your configurations?  It sounds like you need to look at how your input list is configured.

[ABD8]

Yes here is a screenshot of the configuration

[lwolfie]

Without seeing the actual configuration of the action tool, input tool and the dynamic input tool I would suggest the following:

On the Dynamic Input:  Make sure that the file path isn't changing if you are using just a change file/table name.

On the action tool, make sure you have the File - value = selected or use the Update Input Data Tool (Default) in the drop down.  

I've sometimes used a formula tool that creates the updated filepath, by selecting Full Path on line 5 of the input and then adding the sheet names that I want to the file path.  This allows me to use the Action: Change Entire File Path on the Dynamic Input tool.  

As an alternative, you could create a batch macro that would bring in the files in one table.

[ABD8]

Thank you for your help.

Here is an example I put together with dummy data. I built it on the '7.26 Test' file, and when I run the app using the '7.27 Test' file, I am still getting the 7.26 data out. 

[lwolfie · Accepted solution]

That helped.  So a couple of things, you don't need to update the dynamic inputs with the interface tool.

I changed the input for the initial file to bring in your file name and added a formula tool that replaced <List of Sheet Names> with the actual sheet name.  

You can then update the dynamic input to Read "FileName" and the action should be update entire file path.  

The reason you are getting 7.26 data is because your files have the date in the file name and the way you had the dynamic input tool set up was just updating the tab names.  So, this way you are updating for the new file name.