Adding Field Data Transformation Details in a File Request Type

Prerequisites

To add field data transformation details in a file request type, you should have:

  • The Data Transformation Required field selected in the Main section

Procedure

To add field transformation details in a file request type:

  1. Click the Admin link in the Actions / Navigation area.
    A list appears.
  2. From the Admin menu, select F and then click File Request Type.
    A sub-menu appears.
  3. Click the Add option from the File Request Type sub-menu.
    The File Request Type screen appears.
  4. Enter the appropriate details in the Main section, if required.
  5. Enter the appropriate details in the Services and Messages section, if required.
  6. Ensure that the Data Transformation section is expanded when you are defining, editing, or copying a file request type.
  7. Ensure Field Transformation sub-section is expanded. The Field Transformation sub-section contains the following fields:
    Column Name Column Description Mandatory (Yes or No)
    Sequence Used to specify the mapping of field values in CSV or PSV format files, where the sequence number corresponds to the position of the fields in the file.
    Note: You can map or configure the same sequence number to multiple fields (Number of Fields can refer to same field value provided in an individual record). A sequence number ZERO: 0 is reserved for capturing default values.
    		 Yes
    Field Name Used to specify a unique field name, that will contain mapped file sequence field value.
    Note:

    A map with these configured Field Names and the corresponding Field Values is provided as an input to the transformation algorithm.

    If the field data contains the delimiter character, then the each record field should be enclosed with single or double quotes.

    You need to ensure the correct format for HTML character entities.

    		 Yes
    Source Field Path Used to specify the XPath expression that references elements in XML or JSON files from the legacy system. No
    Map Field XPath Used to specify an XPath expression syntax to map elements in business objects during transformation.
    Note: The Search (The Search Icon) icon appears corresponding to the Map Field XPath field. On clicking the search icon, the Field XPath Search window appears.
    		 No
    Required Used to indicate field level validations are necessary for every record while uploading data using the File Transform and Upload (C1-FTRAN) batch. No
    Record Identifier Used to indicate whether the records should be uniquely displayed in the file upload dashboard or not. No
    Skip Validation Used to indicate whether validation should be skipped for length check as per metadata configuration in file upload batch. No
    Edit Input Used to specify whether the field value can be modified during processing, based on the default value configurations. No
    Default Value Used to specify default value that will be applied when generating the record payload. Yes (Conditional)
    Note: This is required when Sequence Number for the mapped field is ZERO: 0. The sequence number ZERO: 0 is reserved for capturing default values.
    Date/Time Format Used to specify the format of date or time values in the input file according to user-defined format. No
  8. Enter the required field transformation details.
  9. One or more transformation details can be configured. If you want to define more than one transformation detail for the file request type, click the Add (The Add Icon) icon and then repeat Step 7and Step 8.
    Note: However, if you want to remove a transformation detail from the file request type, click the Delete (The Delete Icon) icon corresponding to the file segment type.
  10. Click Save.
    The field transformation details are added in the File Request Type.

Related Topics

For more information on... See...
File Request Type List screen File Request Type List
How to define a file request type Defining a File Request Type
How to add services in a file request type Adding Services in a File Request Type
How to add messages in a file request type Adding Messages in a File Request Type
How to add header data transformations in a file request type Adding Header Data Transformation Details in a File Request Type
How to add footer data transformations in a file request type Adding Footer Data Transformation Details in a File Request Type