User Guide › Design › Data Acquisition › Data Loading Forms › Create a Data Loading Form › Input Toolbar › Add Compound Fields

Add Compound Fields

You can add compound fields when you add an input field to the Input table.

To add compound fields

1. On the Input toolbar, click to open the Add Compound Field window.
2. In Name, type a 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. Select the
   1. In Time Format, specify date and time format following which the field is parsed.

      Default value

      Select value - Select from the drop-down list of existing time formats or click Add new time format to create a new format.

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

   1. In Digit grouping symbol, specify the digit grouping symbol for integer and real fields.

      Default value

      Select value - Type a symbol value in the box.

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

   1. In Decimal symbol, specify the decimal symbol for real fields.

      Default value

      Select value - Type a symbol value in the box.

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

5. 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 —or—
   2. Click to update. The Add Compound Field window is displayed showing the added segment.
6. If necessary, repeat step 5 to add more compound segments.

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

7. Click to delete the field unless it is used by another entity. In this case, the entity must be deleted first.
8. Click to edit the field.
9. Click OK. The Mapping step is displayed showing the added field.
10. If necessary, click and repeat steps 1-6 to add more compound fields.
11. Click to delete the field.
12. Click to edit the field.