You can use a lookup to get a value from another table and use it as the output value of this option. For example, you can get a value from a table that is not in the source document.
The other table must have the source field as the single key field. The current value of the 'Modify a value' process is the input of the lookup. As a result, the value that is returned by the lookup is the value of the Return value field.
Before determining the output value of this option, you can apply a type conversion or a transformation.


Standard procedure

1. Click Connectivity studio Integration Design.
2. On the Message tab, in the list, find and select the desired message.
3. Click Edit.
4. In the Mapping section, in the Target record pane, in the list, find and select the desired target record.
5. On the Mapping tab, on the Field mapping tab, in the list, find and select the desired field mapping.
6. Click the Field options tab.
7. Select the Lookup check box.
8. Define the table from which you want to get a value.
  In the Lookup table field, enter or select a value.
9. Define the key field of the table from which you want to get a value.
  In the Lookup key field field, enter or select a value.
 

Note: This key field must be the same field as the source field of the current field mapping.

10. Define the field of the lookup table which value must be returned.
  In the Return field value field, enter or select a value.
11. Before the output value is set, you can apply a type conversion to the returned value.
  In the Type conversions field, enter or select a value.
12. Before the output value is set, you can apply a transformation to the returned value.
  In the Transformation field, enter or select a value.
13. Close the page.

Provide feedback