IBM Support

How to add Merging fields while importing data into the table.

Question & Answer


Question

How to add Merging fields while importing data into the table.

Answer

Summary Of The Issue:-

How to add merging fields while importing data into the table.

Solution:-

In the Import Data wizard in IBM Cognos Incentive Compensation Management you can combine two columns in your data source into one column. For example if you have a month and a year field you can merge the two and create one date field.

Procedure

  1. In step 5 of the Import Data wizard right-click any data source column and click Merge Fields.
    1. a
  2. Type a merge fields name.
  3. Select at least two data fields to merge by dragging a field from the left to the right column.
  4. Type a delimiter. The delimiter is placed between the merged fields.
    Important: You can confirm if your selection is correct by looking at the example in the Create New Field window.
  5. Click OK.

Results:-

You can see your merged field in the data fields column on the map columns window then click auto-match and map with new data fields and complete the wizard to add merge fields while importing data into the table.

Available in all versions

"

[{"Business Unit":{"code":"BU051","label":"N\/A"},"Product":{"code":"SUPPORT","label":"IBM Worldwide Support"},"Component":"","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"All Versions","Edition":"","Line of Business":{"code":"LOB33","label":"N\/A"}}]

Document Information

Modified date:
02 November 2020

UID

ibm10781545

Page Feedback