Using File Browser on Alteryx Server

[gab3]

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

[gabrielvilella · Accepted solution]

You will need to work with the formula option within the action tool to build the correct value the workflow is expecting. I cannot provide you with an exact answer without seeing the incoming data and the expected result.

[gab3]

I was able to achieve what I was trying to do by using a formula to parse out the file name instead of using the full path.