'substring' transform returns 'null' if 'end' index is less than attribute chars count

Something like this?

"deptname": {
    "attributes": {
        "padding": "0",
        "length": "64",
        "input": {
            "attributes": {
                "begin": 0,
                "end": 64,
                "input": {
                    "attributes": {
                        "input": {
                            "attributes": {
                                "attributeName": "DEPT_NAME",
                                "sourceName": "Oracle ERP"
                            },
                            "type": "accountAttribute"
                        }
                    },
                    "type": "trim"
                }
            },
            "type": "substring"
        },
        "type": "rightPad"
    }
}
1 Like