Configure Column Transforms for Connector Uploads

Describes how to modify the data in an upload file by adding and editing fields, and using column transform templates.

This feature can be used to update the first three characters of a field in the upload file or to concatenate two fields into a new third field.

The following options are available for upload connectors:
  • Add/Edit Native Fields

  • Add Additional Fields

  • Apply an Upload Column Transform Template

  • Disable an Upload Column Transform Template

Edit/Remove Columns

On the Configure Column Transformation page, existing column transformations display in the Configured Column Transformation section.

  1. To edit or remove columns, proceed as follows:

    1. To edit a column transformation, choose the column name hyperlink. The Column Transformation dialog box opens. Change the Standard Column Name, File Column Name, Default Value, and Skip on update fields as needed, and then choose Update. For a description of the fields, see the following table of field descriptions.

    2. To remove a column, choose X at the end of the row.

  2. To add/edit native fields, continue with the next task, or to continue with the Transfer Method setup, choose Next Step, and then go to Connectivity Transfer Method Step.

The following table describes the required fields, optional fields, and any applicable rules.
Column Transform Field Descriptions

Field Name

Description

Standard Column Name

When adding a native column, you can select a field from the drop-down list. Standard Column Name refers to the native column name of the upload.

When adding an additional field, you must enter the name of the additional column in the standard SAP Fieldglass format, such as [c] Custom Field, [SA] Signature Authority.

Standard Column Name must be the first field completed.

File Column Name

New name of the column header. The Standard Column Name maps to the File Column Name, if defined.

Default

The initial value for the field. Enclosing quotes aren’t required.

Skip on update

Select this option to add the column value on the initial connector update and skip the column on subsequent updates.

Add/Edit Native Fields

The value of each native field can be modified or mapped to a new column.

  1. To add or edit native fields, on the Configure Column Transformation page, click + Add Native Fields.

    The Column Transformation dialog box displays.

  2. Choose a Standard Column Name from the drop-down list. The list displays all native fields, including any fields modified previously.

  3. Enter/select the other the values based on the field descriptions described in the Transform Column Field Descriptions table.

  4. Choose Update.

  5. To add additional fields, continue with the next task, or to proceed to the Transfer Method setup, choose Next Step, and then go to Connectivity Transfer Method Step.

Add Additional Fields

Any non-native fields not defined in the original upload file can be added to the file. The new fields are formatted as hyperlinks.

  1. To add additional fields, on the Configure Column Transformation page, choose + Add Additional Fields.

    The Column Transformation dialog box opens.

  2. Enter/select the values based on the field descriptions described in the Transform Column Field Descriptions table.

  3. Choose Update.

  4. To apply an upload column transform template, continue with the next task, or to proceed to the Transfer Method step, choose Next Step, and then go to Connectivity Transfer Method Step.

Apply Upload Column Transform Template

Enabling a column transform template transforms upload columns based on the template layout. Column transform templates allow you to make standardized customizations to connectors by defining a set of fields that you apply to one or more connectors. Once enabled, the template is added to the connector.

You can’t create new templates, but once a template is enabled, all fields in the template display along with the manually transformed fields. The template fields can be identified by the flag, Template Enabled.

  1. To apply an upload column transform template, on the Configure Column Transformation page, choose + Apply Template.

    The Apply Upload Column Transform Template dialog box opens.

  2. In Name list, choose an upload column transform template.

    The Description field updates automatically.

  3. To apply the template, choose Enable.

    The template fields display in the Configured Column Transformation section.

  4. To disable a column transform template, continue with the next task, or to finish uploading column transforms, choose Next Step, and then go to Connectivity Transfer Method Step.

Disable Column Transform Template

Disabling a column transform template removes all fields inserted or created by the template.

  1. To disable a column transform template, on the Configure Column Transformation page, choose Disable Template.

  2. To confirm the action, choose OK in the Confirmation dialog box.

  3. To proceed to the Transfer Method step, choose Next Step, and then go to Configure Column Transforms for Connector Uploads.