I noticed using the Input Excel node there's the ability to pick-up an Input by either explicitly defining the file to pick-up, or to use the FilenameExpr which allows you to define an expression to use to pick-up the input file. This is really convenient since it allows me to conditionally define a filepath. However, when using the Output Excel node, there only seems to be the option to explicitly define the filepath and no equivalent "FilenameExpr" field. Is there another node I could use to emulate this piece?
For example, let's say I have several different filepaths as per below. Of these, there would be one path dedicated for each combination of DEV/UAT/PROD and Input/Output. I want to be able to give someone the ability to specify which "environment" they're running for (DEV/UAT/PROD) through a "Run Property" variable and be able to conditionally define which set of Input/Output paths I need to use within Data3Sixty Analyze. I can do this for Inputs right now by using FilenameExpr field, but since the Outputs don't have this field, I'm not sure how to conditionally define the path this way. Is there a way to do this?
Please sign in to leave a comment.