I am using a file browser tool on a workflow on Alteryx Server. As part of the workflow I am using the file path taken from the browser tool to update a PreSQL Statement on the output. The idea is to delete any records that already exist in the database from the same file the workflow is trying to load. This works fine when using Alteryx Designer but when I move the workflow to the Server the file path is coming from
drive (temp location used for staging for the server is my guess) and change every time the workflow is run. Any suggestions on a workaround or is there a way for the tool to input the actual file path and not the temp file path?