Message Mapping editor Spreadsheet pane

Details of the actions available to you in the Spreadsheet pane of the Message Mapping Editor.

The following example shows the Message Mapping editor. The pane that is labelled as 4 in the example is the Spreadsheet pane:
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.

 
Related concepts
Message Mapping editor
Related tasks
Developing message mappings
Adding messages or message components to the source or target
Adding a database as a source or target
Configuring a repeating source and a non-repeating target
Configuring a repeating source and a repeating target
Configuring conditional mappings
Configuring a non-repeating source and a repeating target
Related reference
Message Mapping editor Source pane
Message Mapping editor Target pane
Message Mapping editor Edit pane
Notices | Trademarks | Downloads | Library | Support | Feedback

Copyright IBM Corporation 1999, 2009Copyright IBM Corporation 1999, 2009.
Last updated : 2009-01-07 15:23:02

ar25257_