Mapping Table Comparator

The Mapping Table Comparator component allows you to use an existing Mapping Table Class in a plan.

The Mapping Table Operator component compares row by row the input columns of a mapping table with properties of the plan. The comparison stops when the properties match at least one row of the input columns. The output columns related to the input columns are retrieved in generated properties that you can use in the plan. If no property matches the comparison, the mapping table returns a default value for each generated property.

When it is inserted in the decision tree, the Mapping Table Comparator component creates two separate branches:

• A branch (Row found) that is activated when the comparison is true

• A branch (Row not found) that is activated when the comparison is false

When the component is performed, only one branch is activated depending on the test result.

Use

In a price plan, if you want to apply different prices to branches according to the value of a specific property, you may need to compare a property with a numerical value or another property. To use the Mapping Table Comparator inside your price plan, do the following:

1. After you add the component, choose a mapping table class, a mapping table, a date reference, and two properties to compare with the input columns of the mapping table.

2. Describe the pricing of each decision tree branch by using a Function component.

Example   

An operator needs a price table to retrieve the prices of offers expressed in many currencies depending on the validity periods of the offers. To do that in a price plan, the operator uses a Mapping Table Comparator which contains:

• Mapping table input

• OfferCode: The offer code

• Currency: The currency for the offer code

• ValidityPeriod: The validity period of the offer code

• Mapping table output

• OfferPrice: The price of the offer expressed in the selected currency

Identification area

Name: Type the name of the component (mandatory).

Description: Allows you to type the description of the component (optional).

Definition tab

Mapping Table Class: Provides the list of available mapping table classes. Select the mapping table class that you want to use with the Mapping Table Operator. To open and modify the mapping table, click .

Mapping Table: Provides the list of available mapping tables. Select the mapping table that you want to use with the Mapping Table Operator.

Reference Date: Provides the list of date properties. Select a date property. Each row in the mapping table includes a time period, therefore the Reference Date enables to select the row whose time period includes the Reference Date. If several rows contain the same Reference Date:

• Rule 1: The system selects the row whose start date is closest to the Reference Date

• Rule 2: And if two time periods have the same start date, the shortest time period is selected first

• Rule 3: But if two time periods have the same start date and end date, any duplication is supported, therefore an operation failure is generated

Mapping of Rating Context: Displays the input columns of the mapping table, and allows you to select the properties that you want to compare with the input columns.

• Column Name: Displays the input column name of the mapping table.

• Column Description: Displays the description of the input column of the mapping table.

• Type: Provides the list of two property types: String or Currency. Select a property type.

• Mapping Property: Provides the list of properties relating to the selected type in the Type column. Select the property that you want to compare with the input column.  

Mapping of Generated Properties: Displays the output columns of the mapping table, and allows you to rename the generated properties. When a comparison is true between properties, Reference Date, and input columns, the generated properties retrieve the values of the output column entries.

• Column Name: Displays the output column name of the mapping table.

• Column Description: Displays the description of the output column of the mapping table.

• Type: Displays the type of the generated property: Number or String.

• Generated Property Name: Displays the default generated property that retrieves the output column value of the mapping table. To change the name of the default generated property, double-click the entry, and then type a new name. You can use this new generated property in the plan.