Help with Folder Browse Interface Tool

Ikeman1970

Hello! I am a new Alteryx user and I am stuck - would appreciate some help.

I am working on a workflow (Analytic App) in the flow I have created a field and populated it with the file path of the input file. I want to insert a Folder Brower Interface Tool and take the output from the tool and replace the current value in field filepath. I am trying to force that data update in a Select tool.

In the Action Tool, the configuration is:

Update Value (Default)

SelectField[@field="FilePath"] is highlighted

@field-value="FilePath" is not highlighted

@selected-value="True" is not highlighted

Checkbox "Replace a Specific String" is not checked

Thanks,

Rick

Folder Browse.JPG

Gallery

Best Practices

Accepted answers

SPetrie

Sorry, I missed one step.

The selected folder will not include the final "\" in the path. Because of that, its just adding the file name to the end of the folder so your path ends up being c:\users\diskspacereport\03-25-2024Filename.xtn instead of c:\users\diskspacereport\03-25-2024\Filename.xtn

Update your PathAndFileName formula to be [FilePath]+"\"+[OutputFile] and that should take care of it.

All comments

SPetrie

Your action tool should be connected to the formula tool instead of the select.

Assuming you have a field called FileName that has the current full path, have a new formula setup that is something like "Placeholderpath"+FileGetFileName([FileName])+FileGetExt([FileName])

Have your action tool setup to replace a specific string and replace Placeholderpath (no quotes)

You should then have a new field with the new path and filename.

Ikeman1970

Thanks for the help! Your solution has gotten me part of the way. I am now getting the last subdirectory of the path, but not the complete path. Which is a step up, as I was getting nothing before.

for example: in the Folder Brower tool I navigate to and click OK on - c:\users\Disk Space Report\03-25-2024

And the part of the value that comes through is "03-25-2024" which is appended to the front of my filename and then stored in the working directory (where the app is).

How can I get the full path from the Folder Browser tool?

Placeholder Formula.JPG

PathAndfileName Formula.JPG

Update Action.JPG

SPetrie

Sorry, I missed one step.

Update your PathAndFileName formula to be [FilePath]+"\"+[OutputFile] and that should take care of it.

Ikeman1970

THANKS A MILLION!

What you gave me helped me figure out that I was missing both the "\" and that my field length was too short and truncating my path

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703