Dynamic directory for export path

How do I dynamically change the file path for exporting data? The export tool only has a single input and I can't figure out how to combine a dynamic input/text field so that I can change to where I'm writing data.

The file name itself will always be the same but my output directory will change from month to month. It seems like this should be possible.

Publish

Reporting

Output

Accepted answers

DavidP

Append fields Tool to the rescue!

append fields.png

All comments

DavidP

You can add a formula tool before your output data tool and define your output filepath and filename and also include a datestamp.

datestamp output filename.png

You then configure your Output data tool to take the filename and path from a field. If you don't want this field to show up in your output data, be sure to untick Keep field in Output

datestamp output filename 2.png

jay_chang

So there's no way to combine a text input field with the formula tool while preserving my data?

Following the below works but it means I have to update two places in my workflow each month. Right now I have a single text input tool that is driving the dynamic pathing for 90% of my inputs. I was hoping to use that text input as the driver for my output as well, since my output file is going in the same location as my monthly input files.

vaishalilambe17

="S:\FA Network Admin\Metrics & Reporting\20XX Gold Copy\"&TEXT(EDATE(NOW(),-1),"yyyy")&" Gold Copy\"&TEXT(EDATE(NOW(),-1),"mm")&"\Gross Worth Report (Shares) - "&TEXT(EDATE(NOW(),-1),"mmmm yyyy")&".xlsx"

I want this format

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703