I would like to be able to “build up” filenames and database names from parameters, rather than having to literally have each parameter be the whole value that is then used in an input transformation.
Let’s say I have the following folder structure:
- dataset one
- geo.txt
- address.txt
- dataset two
- geo.txt
- address.txt
Right now, I need to have a single parameter that’s for the full path with a value like “dataset one/geo.txt” (error prone and also I could get sloppy on where I put files in an inconsistent way).
Ideally, I could just have a “folder” parameter (for example with value “dataset one”) and then I build up the actual filename for example by concatenating the value of the “folder” parameter with the constant value of “geo.txt” to derive “dataset one/geo.txt”.