How to use derived fields in the mapping wizard
Derived fields in Supercede allow you to edit your data directly within the platform, eliminating the need to make changes to your source file.
There are a number of different actions you can perform in the derived fields.
Click her to understand the data upload process and how to access derived fields.
1. Create a new value without using existing data
Select the Supercede data heading that doesn't in your dataset.
Enter a value (number or text) you would like to populate it with in the Formula Bar.
Example 1
Example 2
2. Creating a new value utilising existing data
Select the data heading that doesn't exist in your dataset.
You can combine numeric fields using basic operators (+ - / *).
Use the "$" to reference an existing field. A drop down will appear with available fields to select from.
Example
2.1 If Statements
You can use IF statements to test specific conditions and return values based on whether those conditions are true or false.
IF statements in Supercede follow the same syntax as in excel but with specific operators. The available comparison operators are:
Equals to: ==
Does not equal to: !=
Greater than: >
Lesser than: <
Is greater than or equals to: >=
Is lesser than or equals to: <= Self-referencing and nesting
In Supercede, IF statements can reference the same field, allowing for dynamic updates based on conditions.
For an example see 100% Gross Aggregate Limit Original Currency in the table below.
You can also nest multiple IF statements within each other.
For an example see Net Exposure Cedent Share Original Currency in the table below.
Examples
This table provides IF statement examples and an explanation for the different data types by exhibit.
Should you need to check the data type for each field, download the applicable Exhibit Schema.
| Derived Field | Data Type | Example | Explanation |
| Subsection Reference | String |
IF($line_class_of_business _mapping_level_1== "Aviation","Aviation","Healthcare") |
If the value in "Line/Class of Business Mapping Level 1" is "Aviation", return "Aviation" in the "Subsection Reference" field. Otherwise, return "Healthcare". |
| 100% Gross Aggregate Limit Original Currency | Money |
IF($100_gross_aggregate_limit_ original_currency >=5000000,5000000, $100 Gross Aggregate Limit) |
If the value in "100% Gross Aggregate Limit Original Currency" is greater than or equal to 5,000,000, return 5,000,000 in the "100% Gross Aggregate Limit Original Currency" field. Otherwise, retain the existing value. |
| Inception Date (yyyy/mm/dd) | Date |
IF($expiry_date==44557.00, "2022-01-01","2023-01-01") |
If the value in "Expiry Date" equals 44557, return the date "2022-01-01" in the "Inception Date" field. Otherwise, return "2023-01-01". |
| Primary/Excess 0 = Primary Policy 1 = Excess Policy |
Int |
IF($100_attachment_ original_currency <=1000000,"true","false") |
If the value in "100% Aggregate attachment" is less than or equal to 1,000,000, return "true" in the "Primary/Excess 0 = Primary Policy, 1 = Excess" field. Otherwise, return "False". |
| Net Exposure (Cedent Share) Original Currency |
Float |
IF($100_gross_exposure_ original_currency ==0,0,$100%Gross ExposureOriginalCurrency *$LineSizeOfWhole) |
If the value in "100% Gross Exposure Original Currency" is equal to 0, return "0" in the "Net Exposure (Cedent share) Original Currency" field. Otherwise return the value for the calculation: "100% Gross Exposure Cedent Share Original Currency" multiple by "Line Size % of Whole". |
Data types
Different data types require different return values.
Date: Requires a numeric return value in date format, enclosed in quotations.
Float: Requires a numeric return value.
Int: Requires "true" or "false" as return values.
Money: Requires a numeric return value.
String: Requires the return value to be enclosed in quotations.