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.
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. |
Related to | Notes |
---|---|
Define field options |
  |