WebSphere Message Brokers
File: ar25257_
Writer: Cerys Giddings

Reference topic

This build: July 31, 2007 21:36:29

Message Mapping editor Spreadsheet pane

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

 

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 targetConfiguring 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 targetConfiguring conditional mappings

Condition

Define what must evaluate to 'true' to execute subsequent mappings.

Configuring a repeating source and a non-repeating targetConfiguring conditional mappings

Else

Placeholder to execute 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 have 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, 2007Copyright IBM Corporation 1999, 2007. All Rights Reserved.
This build: July 31, 2007 21:36:29

ar25257_ This topic's URL is: