Transform to return NULL

[brennenscott]

Hey @edmarks,

Let me expand on this, because the solution I suggested may still work for you but would require some adjustment. You can use this firstValid transform workaround in tandem with the static transform. As you can see in my previous solution, I employed the use of only the firstValid transform, however, in my solution below, you can see the use of both.

Solution

{
    "name": "FirstValid_Static_Null_Test",
    "type": "firstValid",
    "attributes": {
        "values": [
            {
                "attributes": {
                    "calculatedValue": {
                        "attributes": {
                            "values": [
                                {
                                    "attributes": {
                                        "attributeName": "Special Identifier",
                                        "sourceName": "DLT HR Feed"
                                    },
                                    "type": "accountAttribute"
                                },
                                "null string"
                            ]
                        },
                        "type": "firstValid"
                    },
                    "null": null,
                    "value": "#if($calculatedValue!='null string')$calculatedValue#{else}$null#end"
                },
                "type": "static"
            },
            null
        ]
    }
}

Explanation

What I did here is I simply took the firstValid transform I wrote in my previous solution and nested it in a static transform. This allows for the use of the static transform conditional logic and statements to be used, but in case of a null value, we return a true null. Initially, this would throw an error since the static transform will not appreciate the null reference exception. However, that static transform is also nested within another firstValid transform, which recognizes the error and determines the value is invalid, so it proceeds to the next valid value, which we identify as a true null value. This is then accepted by the transform and is placed in the identity attribute.

Summary

With this, we accomplish the following:

• Conditional logic can be used with the static transform to determine the exact value we want
• For Identities with valid values in this attribute, the identity attribute will be displayed in their Identity Details page
• For Identities without valid values in this attribute, the identity attribute will be determined to be a true null, resulting in the identity attribute not being displayed at all in the Identity Details page.

Does this help clarify, and does this solution work for you?