Hi Team,
I am trying to create a transform which should pick the patterns on priority as below
- [email protected]
- [email protected]
- $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": "[email protected]"
},
"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": "[email protected]"
},
"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": "[email protected]"
},
"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