User Guide : Designing and Executing Map : Mapping Target from Source Data : Mapping Fields Using Advanced View
 
Share this page             
Mapping Fields Using Advanced View
To go to Advanced View, click .
Note:  By default, the Mapping tab shows Simple View. You can change this to always show the Advanced View in the Options > Preferences > Map Designer.
An example is as shown.
Everything that can be configured to control your source to target transformation is displayed in four component windows:
Source tree view where you select tree nodes related to the sources, including constants, lookups, and temporary targets.
Note:  This view changes based on the Map Into filter. This filter determines what you are mapping into: a lookup, a temp target, or a final target. Based on the filter, you are allowed to map only "from" certain sources so that circular mapping references do not occur.
Source grid that changes based on the selected source tree node
Target tree view where you select tree nodes related to the targets. You can use the Map Into filter or the Map Navigator (Map Into section) to select the target you want to map into, which determines the target nodes displayed in the view.
Target grid that changes based on the selected target tree node
The two tree views show the source and target nodes such as record types, groups, fields, and events. Also record instances are displayed in record type hierarchy if the connector supports hierarchy. Depending on the selected node, the configurable information (and a customized action button toolbar) is displayed in the other two component windows to the right. You can resize the component windows.
Key sections:
Map Navigator: Displays the source and target instances. By default, All Targets is selected as a node.
Map Into filter: Allows you to select the target you want to map into. This includes mapping into lookups to set keys, and mapping into temporary targets to create intermediate, in memory data. Based on the selected target, the source side displays only the sources that can be mapped to the chosen target. By default, All Targets is selected. For a lookup type target, only the main sources, constants, and intermediate targets that are above the selected lookup are displayed in the source tree.
The target selected in the Map Into filter is always in synchronization with the map node selected in Map Navigator and vice-versa.
Source Fields: Click All Fields node in the Source tree view to display all the source fields.
Target Fields: Click All Fields node in the Target tree to view all the target fields.
Type to filter: Filters the row data based on the text or value that is typed in the text box. This is applicable only for Reference and Field columns.
Using drag and drop operation, you can map valid source fields and constants to appropriate target fields as applicable. You can also click /download/attachments/24281246/Map_Mapping_MatchBy.png?version=1&modificationDate=1485955669389&api=v2 and use Match By Name and Match By Position options.
Note:  When you drag and drop a field or a constant onto a target field expression cell, it overwrites an existing target expression. When you drag and drop a field onto any cell to the left of a target expression, it either adds the dropped field or overwrites the existing target field based on the selected icons or .
You can add, edit, delete or reorder table fields. The icons are enabled as appropriate. For more information, see Dragging and Dropping Fields From Source to Target.
Note:  In All Fields view, these actions are disabled. Only drag and drop operation is allowed from source to target.
Table icons:
Mapped - A blue icon indicates that the field is mapped to target field. If not mapped, the icon will be grayed out.
Discriminator - A black right arrow indicates that the field is set as discriminator, if applicable.
Action key - Indicates that the field has a action key associated with it.
You can sort the fields in the All Fields node view. The sort arrow is displayed only on the column headers-Record Name and Field when you click on the respective column header once. By default, all the fields are sorted alphabetically by the Fields column in both the source and target sections. When sorting by Record Name column, the sort order is in the order that the record was added and not in the alphabetical order. When sorting by Field column, the view is read-only and sorting is in alphabetical order but does not change the actual order of the fields in the record.
JSON Map Advanced View - Nodes and Actions
In the JSON map > Mapping tab > Advanced View, clicking on each node displays the respective columns. In a few node views, you can perform certain specific actions. The following table provides information about the columns that are available and the actions that you can perform when each tree node is selected.
 
Selected Tree Node
Grid Column
Grid Actions
Source Grid
Target Grid
Source Actions
Target Actions
Constants
Displays the following columns:
Name
Description
Type of constants
Value Expression
 
Add, edit, and/or delete constants. For more information, see Managing Constants.
All Fields (in source tree and target tree)
Displays the following columns:
Icon
Record Name
Group
Field
Description
Type
Size
Properties
Displays the following columns:
Icon
Record Name
Group
Field
Description
Type
Size
Properties
Aggregating
Read-only view.
Read-only view.
All Events (in source tree and target tree)
This view displays:
Both record and source events for all the sources together in source tree > All Events view.
Target events for all targets together in target tree > All Events view.
Displays the following columns:
Source
Target
Event
Details
The columns are read-only.
If events are defined, the Event column lists the previously defined events for a target
Displays the following columns:
Target
Event
Details
The columns are read-only.
Add, edit, and/or delete events
Source_X in source tree view
and Target_X in target tree view
where, X is the number of the source and target connections.
If you have provided a name for the source and target connections, then the names are displayed as nodes in the tree view.
Displays the source connector’s properties that was specified on the Sources tab.
Displays the target connector’s properties that was specified on the Targets tab.
Read-only view.
Read-only view.
TEMP_TARGET_X in Source tree view
 
 
Add, delete, and browse temporary target data. For more information, see Managing Temporary Targets.
Lookup_X in Source tree view
Displays the following columns:
Part and its Value
Property and its Value
Same column names as Source Grid.
Add, delete, and browse lookup data. For more information, see Managing Lookups.
Source_X > All Record Types (in source and target tree views)
Displays the following columns:
Name
Base Type
Description
Length
Schema Origin
Same column names as Source Grid.
Add, delete, duplicate record types. For more information, see Managing Record Types in Advanced View.
All Record Instances (in source and target tree views)
Displays the following columns:
Full Record Path
Record Type
Properties
Same column names as Source Grid.
For multi-mode connectors, two additional columns are displayed:
Target Operation
Target Object Name
Specify the properties. For more information, see Specifying Record Instance Properties.
Delete root record reference. For more information, see Deleting Root Record Reference
For information about multimode connectors, see Setting Up Multimode Target Connectors.
Record Reference: Record (for example, R1:R1 in source and target tree views)
Displays the following columns:
Name
Reference Record Type
NameSpace
Max Occurrence
Min Occurrence
Same column names as Source Grid.
Edit the Name and Record Reference Type columns. The other columns are read-only.
Record Reference: Record > Groups (in source and target tree views)
Displays the following columns:
Group Name
Group Type
Max Occurrence
Min Occurrence
Length
Discriminator
Ruleset Name
Same column names as Source Grid.
Add, delete, and reorder groups.
For more information, see Managing Groups in Advanced View.
Record Reference: Record > Groups > Field Record (in source and target tree views) Example, -R1
Displays the following columns
Mapped Icon
Field
Description
Type
Size
Properties
Displays the following columns
Mapped Icon
Field
Expression
Description
Type
Size
Properties
Aggregating
Add and delete fields, reorder fields, lock or unlock schema, specify field properties, aggregate data (only for target grid)
For more information, see Managing Field Records in Advanced View.
Record Reference: Record > Events (in source and target tree views)
Displays the following columns:
Target
Events
Hover on the Event to view information about the event action details.
Same column names as Source Grid.
Add, edit, delete, copy source events
For more information, see Managing Source Events.
Add, edit, delete, copy target events
For more information, see Managing Target Events
Source Events (in source tree view)
Displays the following columns:
Event
Details
Not applicable
Add, edit, and delete source events.
Not applicable
Source Events > Each Event record (in source tree view)
Displays the following columns:
Event Parameters
Condition Expression
True Actions
False Actions
Not applicable
 
Edit event record
Not applicable
Target Events (in target tree view)
Not applicable
Displays the following columns:
Target
Event
Details
Not applicable
Add, edit, and delete target events.
Target Events > Each Event record (in target tree view)
Not applicable
Displays the following columns:
Event Parameters
Condition Expression
True Actions
False Actions
Not applicable
Edit event record
XML Map Advanced View - Nodes and Actions
In the XML map > Mapping tab > Advanced View, clicking on each node displays the respective columns. In a few node views, you can perform certain specific actions. The following table provides information about the columns that are available and the actions that you can perform when each tree node is selected.
 
Selected Tree Node
Grid Column
Grid Actions
Source Grid
Target Grid
Source Actions
Target Actions
All Fields (in source tree and target tree)
Displays the following columns:
Icon
Record Name
Group
Field
Description
Type
Size
Properties
Displays the following columns:
Icon
Record Name
Group
Field
Description
Type
Size
Properties
Aggregating
Read-only view.
Read-only view.
All Events (in source tree and target tree)
This view displays:
Both record and source events for all the sources together in source tree > All Events view.
Target events for all targets together in target tree > All Events view.
Displays the following columns:
Source
Target
Event
Details
The columns are read-only.
If events are defined, the Event column lists the previously defined events for a target
Displays the following columns:
Target
Event
Details
The columns are read-only.
Add, edit, and/or delete events
All Record Rules > Recognition Rules (source and target tree)
When you add a recognition rule, the following columns are displayed:
Rule Name
Record Type
Operator
Value
High Value
Case
Description
Same column names as Source Grid.
Add, delete, and reorder recognition rules
For more information, see Managing Record Rules in Advanced View
All Record Rules > Validation Rules (source and target tree)
You can add only one validation rule per record. The following columns are displayed:
Record Type
Validation Expression
Same column names as Source Grid.
Add, delete, and reorder recognition rules
For more information, see Managing Record Rules in Advanced View
All Records (in source and target tree views)
Displays the following columns:
Record Name
Length
Locked
Schema Origin
Description
Same column names as Source Grid.
Add, delete, duplicate record types. For more information, see Managing Record Types in Advanced View.
Record Instances (in source and target tree views)
Example, --R1
Displays the following columns:
Mapped Icon
Field
Description
Type
Size
Properties
Same column names as Source Grid.
Add and delete fields, reorder fields, lock or unlock schema, specify field properties, aggregate data (only for target grid)
For more information, see Managing Field Records in Advanced View.
Specify the properties. For more information, see Specifying Record Instance Properties.
Delete root record reference. For more information, see Deleting Root Record Reference
For information about multimode connectors, see Setting Up Multimode Target Connectors.
Record Instance > Events (in source and target tree views)
Displays the following columns:
Event
Action
Parameters
Same column names as Source Grid.
Add, edit, delete events
Record Instance > Recognition Rules (in source and target tree views)
If recognition rules are added, the following columns are displayed:
Rule Name
Record Type
Operator
Value
High Value
Case
Description
Same column names as Source Grid.
Add, delete, and reoder recognition rules. Also, specify record discriminator.
For more information, see Managing Record Rules in Advanced View
Record Instance > Validation Rules (in source and target tree views)
Displays the following columns:
Record Type
Validation Expression
Note:  Each record can have only one validation rule.
Same as columns in Source Grid.
Add validation expression.
Record Instance > Put Condition Rules (target only)
Not applicable
Displays the following columns:
Record Type
Validation Expression
Note:  Each record can have only one put condition rule.
Add condition expression.
Source Events (in source tree view)
Displays the following columns:
Event
Action
Parameters
Not applicable
Add, edit, and delete source events.
Not applicable
Source Events > Each Event record (in source tree view)
Displays the following columns:
Action Parameters
Event Parameters
Not applicable
 
Add, edit, delete, reorder source event actions
Not applicable
Target Events (in target tree view)
Not applicable
Displays the following columns:
Event
Action
Parameters
Not applicable
Add, edit, and delete target events.
Target Events > Each Event record (in target tree view)
Not applicable
Displays the following columns:
Action Parameters
Event Parameters
Not applicable
Add, edit, delete, reorder target event actions.