I am building a workflow where the user selects a file containing multiple sheets that need to be collated for further processing. I am using the **File Browse Tool** to allow the user to choose the file, and then I use the **Dynamic Input Tool** to load the data from multiple sheets.
### **Current Setup:**
- **File Browse Tool** → Allows user to select the Excel file.
- **Three Action Tools**:
1. **Connected to Input Tool** → Updates the file path dynamically.
2. **Connected to Dynamic Input Tool** → Updates the input template path dynamically.
3. **Connected to Modify Query in Dynamic Input Tool** → Replaces a specific string (`'1-6$'`) with the correct sheet name from the newly selected file.
### **Issue:**
The workflow works fine in a standard setup, but when uploaded to the Alteryx Server, it fails because the **Modify Query does not update correctly**. The string `'1-6$'` needs to be dynamically replaced with the correct sheet name based on the user-selected file.
### **What I Need Help With:**
1. How can I ensure the **Modify Query dynamically updates** the sheet name based on the user-selected file?
2. Are my **Action Tools configured correctly**, or is there a better approach to update both the file path and sheet name?
3. Any best practices for handling **Dynamic Input with multiple sheets in a server environment**?
Thanks in advance for any guidance! 😊
Solved! Go to Solution.
Search for your specific use case in community and you'll see numerous posts on it - the key thing is do not use dynamic input. This will break. You must use a batch macro.
I Tried, Can you help me point out to such solution, Thanks!