In the "Input Data" tool, there is an option to "Output File Name as Field". I'm having it output the "Full Path" so I can provide the input file's full file path in my output data. This field is called [FileName], and I'm utilizing a "File Browse" interface tool and having it replace [FileName] with the file path the user selects with the "File Browse" tool. This works when run as an analytic app in Alteryx Designer, but it doesn't work in Alteryx Gallery. The file path that Alteryx Gallery returns is a staging environment: "D:\ProgramData\Alteryx\Service\Staging\gibberish\File Name.txt".
This is not relevant data for my end users. I need the full file path of the input file documented in the output. Is there a way to solve for this while still utilizing the "File Browse" interface tool? I don't want the user to have to provide a full file path as text when running the workflow. Thank you!
I believe from what you said the replace is not being done correctly because it is not changing the address when it is in the gallery in the designer did you test it in several folders to see if it behaves correctly?
Hi geraldo! Yes it works correctly when running as an analytic app in Alteryx Designer. My output shows the correct full file path of the input file; I've tested with more than 1 file to be sure it changes as it should. But I believe Alteryx Gallery places the input file into a staging environment when it runs, so the output shows the file path of the staging environment instead of where the file is actually housed.
looks like absolute path issue, can you check under options - > workflow dependencies and click on absolute for the paths. I always have this issue after upgrades.
Hi GouthamShetty! Yes I did that as well. I think the issue is that the Alteryx Gallery places the input file into a staging environment when it runs, so the output shows the file path of the staging environment instead of where the file is actually housed. I did not want to make users provide file paths (was hoping to utilize the "File Browse" tool so they could just navigate to the file), but because the Alteryx Gallery outputs the incorrect file path, I've had to make users provide the file paths via the "Text Box" tool instead. This way the correct input file paths are documented in the output.
Thanks Keylyn for your response, I understand now. Even I have hardcoded the location using Formula Tool so that Alteryx Gallery does not automatically take The default location.
The file browse is akin to loading it for storage on the temp location in the Server, that's why when you select full path, it directs you to where it's stored on the Server.
What you've done with the text box tool seems to be the best way to overcome this for now... let me do some research and see if there's an alternative.