The File or Filename type property appears on a number of Input Connector and Output Connector nodes. You can use this property type to choose data files and directories that you want to use in your data flows and nodes. You can identify this property by the folder icon that is displayed in the property field. When using this property type, click the folder icon to browse to the data files that you want to use.
Examples:
| Node name | Property name |
|---|---|
| CSV/Delimited Input | Data (from Filename) |
| Directory List | DirectoryName |
| Excel File | File |
| Output CSV/Delimited | Filename |
| Output XML | File |
Alternatively, you can type directly into the property field. Use these formats (applies to nodes that are not deprecated):
- Resource path, for example:
//admin/admin data#data-collection/myDir#data-directory - File URI, for example:
file://Payroll/accountsJan.csv - Absolute file path, for example:
D:/HR/Payroll/accountsJan.csv
Paths must point to a valid workspace and data collection to which you have the required permissions. The path referenced must not violate the allowed list of valid paths.
When a node with a File or Filename type property runs, the system will first look for a resource path. If you have not entered a resource path, or if you do not have access to the entered path, it will look for a file URI. If you have not entered a file URI or do not have access to the entered path, the system will look for an absolute path. It is important to note this resolution order because while resource paths for workspace-based locators start with a // and are distinguishable from file paths, a directory-based resource path would start with / and is not distinguishable from a Linux path or a relative path on Windows.
For example: //admin/admin data#data-collection/myDir#data-directory
This example is pointing to a data directory myDir within the admin data data collection in the admin user's admin (My Documents) workspace. This could also be written as: /Users/admin/admin data/myDir as the Data360 Analyze//admin workspace points to the /Users/admin directory. The resolution order clarifies that /Users/admin/admin data/myDir corresponds to a location in Data360 Analyze.