Currently I have multiple formula tool used through different data sources in my workflow
But that formula tool has the same logic used applied.
It basically has the location to store the file.
The logic used in the formula: "C:\Users\abc\Desktop\folder\folder2\Output\"+[Group]+".xlsx|check"
I would expect "C:\Users\abc\Desktop\folder\folder2\Output\" part of the formula to be added dynamically by the user. The rest is constant.
I want to make the location of the file dynamic as when the user runs using the Analytics app. They should be able to enter the location of the file and then that text should be used in the formula tool.
@madhurinani I just tried it and it didn't work. When looking at the setup, this is because in you current setup, you're looking for 'C:\Users\minani001\Desktop\Bayview Legacy run\BV legacy input\Output' as the replacement target within your action tool:
However, in your Formula expression you actually have 'C:\Users\abc\Desktop\Legacy run\BV legacy input\Output' and because they're different, Alteryx doesn't its target to replace and just leaves it as is. Therefore, you need to update your replacement target to the exact filepath that you're building out the workflow with, even if it's a dummy.
If I do that and open a debug workflow, the replacement works as desired:
@madhurinani whatever you put into your Formula expression that builds the filepath essentially just acts as a placeholder, as it'll always be replaced by the user's selection, and therefore it can be whatever you want it to be (hence why I said dummy, as it just doesn't matter). I've attached the amended app with the Action tool reconfigured. Can you check if it works now? Cheers
@madhurinani I think the issue may actually be caused by using a relative filepath in the 'Output Data' tool which we used to try and get rid of the previous error message (that's not actually an error at the time of running the app). If you make this absolute and then try running the app, does that help? I've just tried it and seemed to work for me.