| //// |
| Licensed to the Apache Software Foundation (ASF) under one |
| or more contributor license agreements. See the NOTICE file |
| distributed with this work for additional information |
| regarding copyright ownership. The ASF licenses this file |
| to you under the Apache License, Version 2.0 (the |
| "License"); you may not use this file except in compliance |
| with the License. You may obtain a copy of the License at |
| http://www.apache.org/licenses/LICENSE-2.0 |
| Unless required by applicable law or agreed to in writing, |
| software distributed under the License is distributed on an |
| "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY |
| KIND, either express or implied. See the License for the |
| specific language governing permissions and limitations |
| under the License. |
| //// |
| :documentationPath: /plugins/transforms/ |
| :language: en_US |
| :page-alternativeEditUrl: https://github.com/apache/incubator-hop/edit/master/plugins/transforms/propertyinput/src/main/doc/propertyinput.adoc |
| |
| = Read data (key, value) from properties files. |
| |
| == Description |
| |
| The Property Input transform reads from a Java properties files. |
| |
| For more information on this file format, read this : http://en.wikipedia.org/wiki/.properties |
| |
| == Options |
| |
| === Files Tab |
| |
| [width="90%", options="header"] |
| |=== |
| |Option|Description |
| |Transform name|Name of the transform this name has to be unique in a single pipeline. |
| |Filenames from field a| |
| * Filename is defined in a field? : the previous transform is giving filenames in a certain field in the input stream. These are read. |
| * Get filename from field : specify the field to the filenames from. |
| |File or directory|Specifies 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|Specifies 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)...|Displays a list of all files that will be loaded based on the current selected file definitions |
| |=== |
| |
| === Content Tab |
| |
| [width="90%", options="header"] |
| |=== |
| |Option|Description |
| |Include filename in output?|Allows you to specify a field name to include the file name (String) in the output of this transform. |
| |Rownum in output|Allows you to specify a field name to include the row number (Integer) in the output of this transform. |
| |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 a| |
| * Add files to result filename : Adds the names of the files read to the result of this pipeline. A unique list is being kept in memory that can be used in the next workflow action in a workflow, for example in another pipeline. |
| |=== |
| |
| === Fields |
| |
| [width="90%", options="header"] |
| |=== |
| |Option|Description |
| |Name|The name of the output field |
| |Column|The attribute to read |
| |Type|The data type to convert to |
| |Format|The format or conversion mask to use in the data type conversion |
| |Length|The length of the output data type |
| |Precision|The precision of the output data type |
| |Currency|The currency symbol to use during data type conversion |
| |Decimal|The numeric decimal symbol to use during data type conversion |
| |Group|The numeric grouping symbol to use during data type conversion |
| |Trim type|The type of trimming to use during data type conversion |
| |Repeat|Repeat the column value of the previous row if the column value is empty (null) |
| |=== |