# Help me how can i generate a unique email address from the data coming from workday . i made one concat trasnform to generate but it doesnt have a unique counter pl help

**URL:** <https://developer.sailpoint.com/discuss/t/help-me-how-can-i-generate-a-unique-email-address-from-the-data-coming-from-workday-i-made-one-concat-trasnform-to-generate-but-it-doesnt-have-a-unique-counter-pl-help/112153>\
**Category:** SHF Discussion and Questions\
**Tags:** identity-security-cloud\
**Created:** [April 16, 2025, 7:46am UTC](https://developer.sailpoint.com/discuss/t/help-me-how-can-i-generate-a-unique-email-address-from-the-data-coming-from-workday-i-made-one-concat-trasnform-to-generate-but-it-doesnt-have-a-unique-counter-pl-help/112153 "2025-04-16T07:46:59Z")\
**Posts on this page:** 12\
**Page:** 1

<div class="post-metadata">

**Author:** ![Rakesh\_Singh\_1234](https://avatars.discourse-cdn.com/v4/letter/r/3be4f8/32.png) [@Rakesh\_Singh\_1234](https://developer.sailpoint.com/discuss/u/Rakesh_Singh_1234)\
**Post date:** [April 16, 2025, 7:46am UTC](https://developer.sailpoint.com/discuss/t/help-me-how-can-i-generate-a-unique-email-address-from-the-data-coming-from-workday-i-made-one-concat-trasnform-to-generate-but-it-doesnt-have-a-unique-counter-pl-help/112153/1 "2025-04-16T07:46:59Z")

</div>

below is my transform for mail generation

````auto
{
    "id": "90c9c4c8-d117-4023-a037-00ce0633e3f2",
    "name": "DOW_EMAIL_GENERATION_WD",
    "type": "concat",
    "attributes": {
        "values": [
            {
                "type": "identityAttribute",
                "attributes": {
                    "name": "inititalforaddisplayname"
                }
            },
            {
                "type": "identityAttribute",
                "attributes": {
                    "name": "lname"
                }
            },
            "@",
            {
                "type": "identityAttribute",
                "attributes": {
                    "name": "domainbasedontenant"
                }
            }
        ]
    },
    "internal": false
}```
````

---

<div class="post-metadata">

**Author:** ![officialamitguptaa](https://sea1.discourse-cdn.com/sailpoint/discuss/user_avatar/developer.sailpoint.com/officialamitguptaa/32/6624_2.png) [@officialamitguptaa](https://developer.sailpoint.com/discuss/u/officialamitguptaa)\
**Post date:** [April 16, 2025, 8:09am UTC](https://developer.sailpoint.com/discuss/t/help-me-how-can-i-generate-a-unique-email-address-from-the-data-coming-from-workday-i-made-one-concat-trasnform-to-generate-but-it-doesnt-have-a-unique-counter-pl-help/112153/2 "2025-04-16T08:09:31Z")

</div>

@Rakesh_Singh_1234 -

Is this transform intended for an Identity Profile mapping or a Create Account profile?

If you’re working with a Create Account profile, you can utilize the **“Create Unique LDAP Attribute”** generator to create unique account attributes beyond just the username.

To configure this, go to the **“Create Account”** configuration page of your source and set up the **email** attribute accordingly.

Make sure your Identity Profile includes an attribute that extracts the first initial of the user’s first name — this will be essential for building your desired pattern.

 ![image](https://global.discourse-cdn.com/sailpoint/original/3X/c/f/cf8b6468d275ba74f2648db9c5a4e8f498695da3.png)

But if it for **Identity Profile Mapping** then You would need a custom rule to make that work in an identity profile mapping.

[https://developer.sailpoint.com/idn/docs/rules/cloud-rules](https://developer.sailpoint.com/idn/docs/rules/cloud-rules)

Hope this helps.

---

<div class="post-metadata">

**Author:** ![Rakesh\_Singh\_1234](https://avatars.discourse-cdn.com/v4/letter/r/3be4f8/32.png) [@Rakesh\_Singh\_1234](https://developer.sailpoint.com/discuss/u/Rakesh_Singh_1234)\
**Post date:** [April 16, 2025, 9:03am UTC](https://developer.sailpoint.com/discuss/t/help-me-how-can-i-generate-a-unique-email-address-from-the-data-coming-from-workday-i-made-one-concat-trasnform-to-generate-but-it-doesnt-have-a-unique-counter-pl-help/112153/3 "2025-04-16T09:03:34Z")

</div>

@officialamitguptaa hey amit we are making at ideentity profile level and then mapping it in downstream app create account(like AD ) for that can it be done through a transform by adding a unique identitifier in trasnform itself\>??

---

<div class="post-metadata">

**Author:** ![iamology](https://sea1.discourse-cdn.com/sailpoint/discuss/user_avatar/developer.sailpoint.com/iamology/32/6964_2.png) [@iamology](https://developer.sailpoint.com/discuss/u/iamology)\
**Post date:** [April 16, 2025, 12:16pm UTC](https://developer.sailpoint.com/discuss/t/help-me-how-can-i-generate-a-unique-email-address-from-the-data-coming-from-workday-i-made-one-concat-trasnform-to-generate-but-it-doesnt-have-a-unique-counter-pl-help/112153/4 "2025-04-16T12:16:14Z")

</div>

Have a look at this one

> **[Username Generator | SailPoint Developer Community](https://developer.sailpoint.com/docs/extensibility/transforms/operations/username-generator)**
>
> Derive a unique value for an attribute in an account create profile.

---

<div class="post-metadata">

**Author:** ![officialamitguptaa](https://sea1.discourse-cdn.com/sailpoint/discuss/user_avatar/developer.sailpoint.com/officialamitguptaa/32/6624_2.png) [@officialamitguptaa](https://developer.sailpoint.com/discuss/u/officialamitguptaa)\
**Post date:** [April 16, 2025, 12:26pm UTC](https://developer.sailpoint.com/discuss/t/help-me-how-can-i-generate-a-unique-email-address-from-the-data-coming-from-workday-i-made-one-concat-trasnform-to-generate-but-it-doesnt-have-a-unique-counter-pl-help/112153/5 "2025-04-16T12:26:33Z")

</div>

@Rakesh_Singh_1234 -

I have attached a sample. Let me know if it works

```auto
{
    "name": "email_Generator",
    "transform": {
      "type": "usernameGenerator",
      "attributes": {
        "sourceCheck": true,
        "patterns": [
          "$initials.$ln@$domain",
          "$initials.$ln.${uniqueCounter}@$domain"
        ],
        "initials": {
          "type": "identityAttribute",
          "attributes": {
            "name": "inititalforaddisplayname"
          }
        },
        "ln": {
          "type": "identityAttribute",
          "attributes": {
            "name": "lname"
          }
        },
        "domain": {
          "type": "identityAttribute",
          "attributes": {
            "name": "domainbasedontenant"
          }
        }
      }
    },
    "attributes": {
      "cloudMaxSize": "100",
      "cloudMaxUniqueChecks": "5",
      "cloudRequired": "true"
    },
    "isRequired": false,
    "type": "string",
    "isMultiValued": false
  }

```

Thank you!

---

<div class="post-metadata">

**Author:** ![Rakesh\_Singh\_1234](https://avatars.discourse-cdn.com/v4/letter/r/3be4f8/32.png) [@Rakesh\_Singh\_1234](https://developer.sailpoint.com/discuss/u/Rakesh_Singh_1234)\
**Post date:** [April 16, 2025, 12:47pm UTC](https://developer.sailpoint.com/discuss/t/help-me-how-can-i-generate-a-unique-email-address-from-the-data-coming-from-workday-i-made-one-concat-trasnform-to-generate-but-it-doesnt-have-a-unique-counter-pl-help/112153/6 "2025-04-16T12:47:39Z")

</div>

hey thanks @officialamitguptaa but my question is can i directly apply this at identity profile level?

---

<div class="post-metadata">

**Author:** ![Rakesh\_Singh\_1234](https://avatars.discourse-cdn.com/v4/letter/r/3be4f8/32.png) [@Rakesh\_Singh\_1234](https://developer.sailpoint.com/discuss/u/Rakesh_Singh_1234)\
**Post date:** [April 16, 2025, 12:57pm UTC](https://developer.sailpoint.com/discuss/t/help-me-how-can-i-generate-a-unique-email-address-from-the-data-coming-from-workday-i-made-one-concat-trasnform-to-generate-but-it-doesnt-have-a-unique-counter-pl-help/112153/7 "2025-04-16T12:57:03Z")

</div>

![image](https://global.discourse-cdn.com/sailpoint/original/3X/0/c/0c033dc27926e60876615ed1742ed71acf6a091a.png)  
@officialamitguptaa giving me errror

---

<div class="post-metadata">

**Author:** ![officialamitguptaa](https://sea1.discourse-cdn.com/sailpoint/discuss/user_avatar/developer.sailpoint.com/officialamitguptaa/32/6624_2.png) [@officialamitguptaa](https://developer.sailpoint.com/discuss/u/officialamitguptaa)\
**Post date:** [April 16, 2025, 1:42pm UTC](https://developer.sailpoint.com/discuss/t/help-me-how-can-i-generate-a-unique-email-address-from-the-data-coming-from-workday-i-made-one-concat-trasnform-to-generate-but-it-doesnt-have-a-unique-counter-pl-help/112153/8 "2025-04-16T13:42:09Z")

</div>

@Rakesh_Singh_1234 -

You need to delete the old one first and then create this one. If you are modifying the existing one, make sure to keep the same name,id etc. Just update the logic.

---

<div class="post-metadata">

**Author:** ![iamnithesh](https://sea1.discourse-cdn.com/sailpoint/discuss/user_avatar/developer.sailpoint.com/iamnithesh/32/4884_2.png) [@iamnithesh](https://developer.sailpoint.com/discuss/u/iamnithesh)\
**Post date:** [April 16, 2025, 1:58pm UTC](https://developer.sailpoint.com/discuss/t/help-me-how-can-i-generate-a-unique-email-address-from-the-data-coming-from-workday-i-made-one-concat-trasnform-to-generate-but-it-doesnt-have-a-unique-counter-pl-help/112153/9 "2025-04-16T13:58:38Z")

</div>

In addition to what @officialamitguptaa mentioned, you cannot change the root transform type once it’s created

---

<div class="post-metadata">

**Author:** ![Rakesh\_Singh\_1234](https://avatars.discourse-cdn.com/v4/letter/r/3be4f8/32.png) [@Rakesh\_Singh\_1234](https://developer.sailpoint.com/discuss/u/Rakesh_Singh_1234)\
**Post date:** [April 17, 2025, 7:08am UTC](https://developer.sailpoint.com/discuss/t/help-me-how-can-i-generate-a-unique-email-address-from-the-data-coming-from-workday-i-made-one-concat-trasnform-to-generate-but-it-doesnt-have-a-unique-counter-pl-help/112153/10 "2025-04-17T07:08:05Z")

</div>

@officialamitguptaa i am not able to save it showing error .can we use the transfrom only in provisioning policy?

---

<div class="post-metadata">

**Author:** ![Rakesh\_Singh\_1234](https://avatars.discourse-cdn.com/v4/letter/r/3be4f8/32.png) [@Rakesh\_Singh\_1234](https://developer.sailpoint.com/discuss/u/Rakesh_Singh_1234)\
**Post date:** [April 17, 2025, 12:37pm UTC](https://developer.sailpoint.com/discuss/t/help-me-how-can-i-generate-a-unique-email-address-from-the-data-coming-from-workday-i-made-one-concat-trasnform-to-generate-but-it-doesnt-have-a-unique-counter-pl-help/112153/11 "2025-04-17T12:37:52Z")

</div>

@officialamitguptaa i got an error when i applied this transform in prov policy of ad

An unexpected error occurred: Unable to generate a unique value for ‘118112’, action UniqueAccountIdValidator[nativeIdentity=jjones@domain.com,app=Active Directory] is not retry-able due to ConnectorException: [InvalidConfigurationException] [Error details] Required string attribute ‘User’ is not defined.It must have a valid value.

---

<div class="post-metadata">

**Author:** ![system](https://global.discourse-cdn.com/sailpoint/original/2X/f/f2136700ed5e3703e0b85e02f6be799dacca7735.png) [@system](https://developer.sailpoint.com/discuss/u/system)\
**Post date:** [June 16, 2025, 12:38pm UTC](https://developer.sailpoint.com/discuss/t/help-me-how-can-i-generate-a-unique-email-address-from-the-data-coming-from-workday-i-made-one-concat-trasnform-to-generate-but-it-doesnt-have-a-unique-counter-pl-help/112153/12 "2025-06-16T12:38:19Z")

</div>

This topic was automatically closed 60 days after the last reply. New replies are no longer allowed.