Hi Team,
I am trying to create a transform which should pick the patterns on priority as below
- $fi.$ln@mail.com
- $fi.$mi.ln@mail.com
- $fi.$ln(uniquecounter)@mail.com
The problem is if two users are having same firstname and lastname this transform still populate the same email for both users, as they are not null.
How can i construct the transform as such it should check unique values too. Is this possible?
Below is the snippet I’m using to achieve this but it is not working as expected.Can you please help
{
"attributes": {
"values": [
{
"attributes": {
"firstInitial": {
"type": "substring",
"attributes": {
"input": {
"type": "accountAttribute",
"attributes": {
"attributeName": "firstName",
"sourceName": "Staff Joiner"
}
},
"begin": 0,
"end": 1
}
},
"lastName": {
"type": "identityAttribute",
"attributes": {
"name": "lastname"
}
},
"middleInitial": {
"type": "substring",
"attributes": {
"input": {
"type": "accountAttribute",
"attributes": {
"attributeName": "middleName",
"sourceName": "Staff Joiner"
}
},
"begin": 0,
"end": 1
}
},
"value": "$firstInitial.$lastName@leeds.ac.uk"
},
"type": "static"
},
{
"attributes": {
"firstInitial": {
"type": "substring",
"attributes": {
"input": {
"type": "accountAttribute",
"attributes": {
"attributeName": "firstName",
"sourceName": "Staff Joiner"
}
},
"begin": 0,
"end": 1
}
},
"lastName": {
"type": "identityAttribute",
"attributes": {
"name": "lastname"
}
},
"middleInitial": {
"type": "substring",
"attributes": {
"input": {
"type": "accountAttribute",
"attributes": {
"attributeName": "middleName",
"sourceName": "Staff Joiner"
}
},
"begin": 0,
"end": 1
}
},
"value": "$firstInitial.$middleInitial.$lastName@leeds.ac.uk"
},
"type": "static"
},
{
"attributes": {
"firstInitial": {
"type": "substring",
"attributes": {
"input": {
"type": "accountAttribute",
"attributes": {
"attributeName": "firstName",
"sourceName": "Staff Joiner"
}
},
"begin": 0,
"end": 1
}
},
"lastName": {
"type": "identityAttribute",
"attributes": {
"name": "lastname"
}
},
"middleInitial": {
"type": "substring",
"attributes": {
"input": {
"type": "accountAttribute",
"attributes": {
"attributeName": "middleName",
"sourceName": "Staff Joiner"
}
},
"begin": 0,
"end": 1
}
},
"value": "$firstInitial.$lastName$uniquecounter@leeds.ac.uk"
},
"type": "static"
}
]
},
"type": "firstValid",
"name": "DelimitedEmailTransform"
}
DelimitedEmailTransform.txt (3.6 KB)
Sorry was not able to upload the snippet correctly hence uploaded json file format