Property Input
Description
Property Input reads key-value pairs from Java properties files and outputs them as rows in the data stream. Use this step when your workflow needs to load configuration settings, environment-specific parameters, or any data stored in the standard Java properties format. Each key-value pair from the file becomes a separate row, making it easy to process, filter, or map configuration values to variables or fields in downstream steps.
Configurations:
| Field Name | Description |
|---|---|
| Step name | Specify the name of the step. This name can me modified from the default name and has to be unique within the workflow. |
| Filenames from field | Enable ‘Filename is defined in a field’ checkbox to read filenames from a previous field. |
| Get filename from field | Specify the field to the filenames from. |
| File or directory | Specify the location and/or name of the input text file. Important: Click Add to add the file/directory/wildcard combination to the list of selected files (grid) below. |
| Regular expression | Specify the regular expression you want to use to select the files in the directory specified in the previous option. |
| Selected Files | Contains a list of selected files (or wildcard selections) and a property specifying if file is required or not. If a file is required and it is not found, an error is generated; otherwise, the file name is skipped. |
| Show filenames(s)... | Click button to display a list of all files that will be loaded based on the current selected file definitions. |
| Content Tab: | |
| Include filename in output? | Enable checkbox to include the file name (String) in the output of this step. |
| Rownum in output | Specify a field name to contain the row number (Integer) in the output of this step. |
| Reset rownum per file? | Enable this option if you want the generated row number (optional) to be reset (to 1) at the start of every individual file. |
| Limit | Limits the number of rows to this number (zero (0) means all rows). |
| Result filenames | Enable checkbox to add the names of the files read to the result of this workflow. A unique list is being kept in memory that can be used in the next process entry in a process, for example in another workflow. |
| Fields Tab: | |
| Name | Specify the name of the output field. |
| Column | Specify the attribute to read. |
| Type | Specify the data type to convert to. |
| Format | Specify the format or conversion mask to use in the data type conversion. |
| Length | Specify the length of the output data type. |
| Precision | Specify the precision of the output data type. |
| Currency | Specify the currency symbol to use during data type conversion. |
| Decimal | Specify the numeric decimal symbol to use during data type conversion. |
| Group | Specify the numeric grouping symbol to use during data type conversion. |
| Trim type | Specify the type of trimming to use during data type conversion. |
| Repeat | Select Y/N. Select Y to repeat the column value of the previous row if the column value is empty (null). |
| Additional Output Fields Tab: | |
| Short filename field | Specify a fieldname to hold the short filename. |
| Extension field | Specify a fieldname to hold the filename extension. |
| Path field | Specify a fieldname to hold the file path. |
| Size field | Specify a fieldname to hold the file size. |
| Is hidden field | Choose from Y/N. Choose Y to hide field. Default is N. |
| Last modification field | Specify a fieldname to hold the last modification date. |
| Uri field | Specify a fieldname to hold the Uri (e.g. file:///C:/temp/file.txt). |
| Root Uri field | Specify a fieldname to hold the Root Uri (e.g. file:///C:/). |