Dynamic Input not using the file selected in File Browse - how to fix?

Question

Hey, I have a pretty simple workflow set up which was running correct when I finished it. It's set up as an App to upload a Excel file each week, and process the data and create a table in BigQuery. The workflow is still running successfully with no errors, however the browse tool and the data table in bigquery and not populating with the correct data - they are populating with the data from the excel doc I originally used to set up the workflow (I can tell because this was dated 02/10 and my new file is 16/10).

I believe the issue is because of the Dynamic Input tool, this still references the origin 1002 file in the "Input Data Source Template" section - how do I fix this so the dynamic input looks for the same file as the one selected in the File Browse?

caltang · Answer

Yup

You've got the change the path - otherwise you're referencing the sheetname of the file you are referencing WITHIN the dynamic input tool.

Please find the following to help:

* https://help.alteryx.com/current/en/designer/tools/developer/dynamic-input-tool.html
* https://www.thedataschool.co.uk/marc-reid/working-dynamic-input-alteryx/ 
* https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/Dynamic-input-how-to-get-input-data-configuration-options-in/td-p/1105107

rachaelkertes · Answer

here is the config for Dynamic Input.

I can only run the flow successfully if I update both input and dynamic input to the newest file.

dynamic-input-screenshot.PNG

korva · Answer

I am having the same issue. I have a template data source that is always the output, regardless of what file is input into the file browse tool. I am not sure if the issue is in the File Browse or the Dynamic Input, but here is the Dynamic Input configuration. All files being used are .xlsx