This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
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.
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.
Sure you can. If there is a field with the file name and path defined in your text input tool (or anywhere else in your dataset) you can use that as the field to tell the Output data tool what to use for writing the file.
You can use the formula tool to update that field and insert a datestamp for instance. I suggest you play around with the different options in the Output Data tool. You can take just the filename from a field, add a prefix or a suffix to the existing field name, or take the entire path from a field.
I don't think I'm following. Below is my final set of steps:
If I put a formula tool after that final step, then I need to connect the output of my filter to that formula tool, which means I can't connect my text input.
If I connect my text input to the output, then I don't get any data.
What tool allows me to connect my text input to my final data output? I can't use a join because there are no matching fields. I can't use a union because then that just stacks my data on top of each other.