Home

Derived Field: coll_product_group

Back to List Edit Test
Field Details

Field Name:

coll_product_group

Source Table:

evolved_records

Status:

Active

Expression Type:

jinja

Output Type:

TEXT

Version:

v1

Used In:

Summaries

Display Name:

Product Group

Expression:

            {% if raw_data.product is defined %}
                {% set product = raw_data.product|upper %}
                {% if product in ["TWL", "PL", "PLN", "BL"] %}
                    "PERSONAL"
                {% elif product in ["ALN", "CAR", "VL", "TW"] %}
                    "VEHICLE"
                {% elif product in ["HL", "LAP", "MORT", "MTL"] %}
                    "MORTGAGE"
                {% elif product in ["BIL", "BZL", "MSME"] %}
                    "BUSINESS"
                {% else %}
                    "OTHER"
                {% endif %}
            {% elif raw_data.product_code is defined %}
                {% set product_code = raw_data.product_code|upper %}
                {% if product_code in ["TWL", "PL", "PLN", "BL"] %}
                    "PERSONAL"
                {% elif product_code in ["ALN", "CAR", "VL", "TW"] %}
                    "VEHICLE"
                {% elif product_code in ["HL", "LAP", "MORT", "MTL"] %}
                    "MORTGAGE"
                {% elif product_code in ["BIL", "BZL", "MSME"] %}
                    "BUSINESS"
                {% else %}
                    "OTHER"
                {% endif %}
            {% else %}
                "UNKNOWN"
            {% endif %}
Dependencies

No dependencies defined

Joins

No joins defined

Registry Information

No registry entry found

Version History

No version history available

Field Usage

Referenced by: