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?
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
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:
