Details of the actions available to you in the Spreadsheet pane of the Message Mapping Editor.
Use the Spreadsheet pane to invoke a number of actions, a list of which is displayed when you right-click within the Spreadsheet pane. The following table describes the available actions.
Action | Description | Related tasks |
---|---|---|
Undo |
Undo previous action |
|
Redo |
Redo previous action |
|
Revert |
Discard |
|
Open Declaration (message) | Display the element definition from the message
set. For this action to be available, select any message element except LocalEnvironment or Headers. |
|
Open Declaration (database) | Display the database, schema, or table definition
from the database. For this action to be available, select any database object. |
|
Add Sources and Targets |
Add a message definition to a target. |
Adding messages or message components to the source or target, Adding a database as a source or target |
Copy |
Copy the selected item to the clipboard. |
|
Paste |
Paste the item from the clipboard. |
|
Delete |
Remove a row from the Spreadsheet. |
|
For |
Define a repeating condition. |
Configuring a repeating source and a non-repeating target, Configuring a repeating source and a repeating target |
If |
Placeholder for a new Condition block, to contain one or more Conditions. |
Configuring a repeating source and a non-repeating target, Configuring conditional mappings |
Condition |
Define what must evaluate to 'true' to process subsequent mappings. |
Configuring a repeating source and a non-repeating target, Configuring conditional mappings |
Else |
Placeholder to process subsequent mappings if previous Condition does not evaluate to 'true'. |
Configuring conditional mappings |
Select Data Source |
Define a database to be used in the mapping. |
|
Populate |
Expand a structure so that each of its children has a row in the spreadsheet. |
|
Insert After |
Create a number of new rows in the spreadsheet to set the values of specific instances of a repeating field. Can also be used to insert any non-repeating element, attribute or database column if valid at the selected location. |
Configuring a non-repeating source and a repeating target |
Insert Before |
Create a number of new rows in the spreadsheet to set the values of specific instances of a repeating field. Can also be used to insert any non-repeating element, attribute or database column if valid at the selected location. |
Configuring a non-repeating source and a repeating target |
Replace |
Substitute an element, attribute or database column in the spreadsheet with a similar item, retaining the mapping expression and any child mapping statements. |
|
Save |
Save the .msgmap file. |