User Guide › Design › Data Acquisition › Adapters › Adding Adapters › Add a Text File Adapter › Input Toolbar › Adding Input Fields

Adding Input Fields

To add an input field to the Input table:

1. In the Input Field Details window, specify one data field of the original data row, or a compound field. It may contain one or more field nodes according to the data source number of input fields.
2. In Name, type name for this field, to be referred to by other elements.
3. In Type, select the data type of the field (String, Integer, Real or Time).
4. In Advanced settings, click to expand the panel:
   1. In Time Format, specify date and time format following which the field is parsed (Default value or Select value). If Default value is selected, the value from the General tab of the General step is taken.

   If no time format is available or none of the available ones is desired, click Add new time format. The Time Format window is displayed.

   • Enter the required information.
   • Click Save. For more information, see Adding Time Formats.

   Note: This attribute is enabled when Type is set to Time.

   1. In Digit grouping symbol, specify the default digit grouping symbol for integer and real fields (Default value or Select value). If Default value is selected, the value from the General tab of the General step is taken.

   Note: This attribute is enabled when Type is set to Integer or Real.

   1. In Decimal symbol, specify the decimal symbol for fields (Default value or Select value). If Default value is selected, the value from the General tab of the General step is taken.

   Note: This attribute is enabled when Type is set to Real.

5. In Source, select a field to add from the drop-down list.

To add a data source field:

1. In Source, select Data Source. The field value is taken from the event coming from data source. Values of fields are taken in the same order coming from the data source.
2. Click OK. The Details tab is displayed showing the added field.
3. If necessary, click Add Field and repeat steps 1-2 to add more data source fields.

   Note: The order of the fields can be changed by clicking or .

4. Click to delete the field unless it is used by another entity. In this case, the entity must be deleted first.
5. Click to edit the field.

To add a compound field:

1. In Source, select Compound. The field gets its value after making some sort of manipulation on other field values or constants.

   Note: At least one compound segment must exist.

2. Click Add compound segment to create a compound segment.
   1. Fill in the columns as follows:
   • Source Field - The field to be based on. The referred field should already be defined.
   • Xpath Expression - The manipulating xpath expression.
   • Regular Expression - The manipulating regular expression. For more information on regular expression syntax, see Regular Expression Syntax.
   • Match Case - Define if the regular expression matching is case sensitive.
   • Selection Start - The text extraction start position, starting from zero.
   • Selection Length - the text extraction size.
   • Prefix - A string to be prefixed to the manipulation result.
   • Suffix - A string to be suffixed to the manipulation result.
   1. Click to cancel the operation and return to the Input field details page.
   2. Click to update. The Input field details page is displayed showing the added segment.
3. If necessary, repeat step 2 to add more compound segments.

   Note: The order of the segments can be changed by clicking or .

4. Click OK. The Details tab is displayed showing the added field.
5. If necessary, click Add Field and repeat steps 1-4 to add more compound fields.

   Note: The order of the fields can be changed by clicking or . The field order is limited since each field is used by another entity and therefore cannot be placed above that entity in the order.

6. Click to delete the field unless it is used by another entity. In this case, the entity must be deleted first.
7. Click to edit the field.

To add a constant field:

1. In Source, select Constant. The Constant Value field is displayed.
2. Type the value to be matched. When the field’s type is Time, the constant value is a formatted string according to the TimeFormat.
3. Click OK. The Details tab is displayed showing the added field.
4. If necessary, click Add Field and repeat steps 1-3 to add more constant fields.

   Note: The order of the fields can be changed by clicking or .

5. Click to delete the field unless it is used by another entity. In this case, the entity must be deleted first.
6. Click to edit the field.

To add a title field:

1. In Source, select Title. The Title Name drop-down list is displayed.
2. Select the title field name. The referred field should already be defined. The Title Name list indicates the available data source input structure fields.
3. Click OK. The Details tab is displayed showing the added field.
4. If necessary, click Add Field and repeat steps 1-3 to add more title fields.

   Note: The order of the fields can be changed by clicking or . The field order is limited, since each field is used by another entity, and therefore cannot be placed above that entity in the order.

5. Click to delete the field unless it is used by another entity. In this case, the entity must be deleted first.
6. Click to edit the field.

To add a File Name field:

1. In Source, select File Name. The field value is taken from the data source file name.
2. Click OK. The Details tab is displayed showing the added field.
3. If necessary, click Add Field and repeat steps 1-2 to add more file fields.

   Note: The order of the fields can be changed by clicking or .

4. Click to delete the field unless it is used by another entity. In this case, the entity must be deleted first.
5. Click to edit the field.