Lookup Transform - Default Value

I typically use the substring transform with a begin value of 0 to access the implicit input from the identity profile mapping within a transform. For example:

{
    "name": "Identity-Department",
    "type": "lookup",
    "attributes": {
        "table": {
            "Value to Replace1": "ReplacementValue1",
            "Value to Replace2": "ReplacementValue2",
            "default": {
                "type": "firstValid",
                "attributes": {
                    "values": [
                        {
                            "type": "substring",
                            "attributes": {
                                "begin": 0
                            }
                        },
                        {
                            "type": "static",
                            "attributes": {
                                "value": "Unknown"
                            }
                        }
                    ]
                }
            }
        }
    }
}
4 Likes