Skip to Content

How to allow .scot email domain in base data cleanse transform ?

Hi All,

Scenario:
We are using Base data cleanse transform for cleansing the email address & recently business has decided to go with emails having .scot domain. Unfortunately, this email address when parsed by the transform, returns a NULL value in the output.

This means, transform is not accepting the domain.

Can anyone here suggest me the ways to allow this domain to be successfully parsed.
Also, I'm not looking for any manual solution and moreover looking for any SAP Notes or any existing solution around this.

Note:
We do not have Information steward installed to modify the existing cleansing package.

Thanks in advance,
Santosh G.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • Jun 20, 2017 at 02:00 PM

    Is is the tool to maintain/customise that type of information, it's part of the standard cleansing package. If you don't have it installed, I am afraid I cannot help.

    Add comment
    10|10000 characters needed characters exceeded

  • Jun 27, 2017 at 05:06 PM

    Hi Santosh,

    The domain list that Data Cleanse uses to parse email addresses is a hard-coded list and is not modifiable even with Information Steward. Note that the domain information that can be modified via Information Steward Cleansing Package Builder is used to be able to flag internet service provider (ISP) emails via the Email_is_ISP output field. The information maintained in that list does not impact how emails are parsed.

    I would suggest logging an enhancement request via SAP Idea Place to add any missing domains to a future release of the cleansing package and to also request that this internal domain list be made modifiable via Information Steward Cleansing Package Builder module in the future.

    Regards,

    Doug

    Add comment
    10|10000 characters needed characters exceeded

    • Hi Doug,

      Sorry to bother you again, maybe understanding is still unclear.

      I installed information steward, created a dummy package out of Person_firm. In the EditReferenceData -> Email section I added a custom domain, say "abc.scot". I tried to validate using adding the sample data.

      For ex:

      input email1 = a@b.scot

      but, this email didn't get parsed under standard email output field but the output for it got logged under extra_field(not expected). The standard domain examples were working perfectly fine and the successfully getting parsed under standard email output field.

      I just want to know,

      1. what is the use of adding custom domains to the email reference data if they're not getting parsed?

      2. Also that means we cannot add custom domains and use it in our cleansing job?

      Regards,
      Santosh G.

  • Aug 07, 2017 at 03:32 PM

    Hi Santosh,

    As mentioned in my original response, adding the domain in Cleansing Package Builder will not impact the domains that Data Cleanse can parse. The email information you can add in CPB is used solely to identify if an email address (that was parsed successfully) is an ISP so they can be flagged as such. The email domains that can be successfully identified are hard-coded in the product and can not be added to at this time.

    Please consider submitting an enhancement request via SAP Idea Place to add the missing domains in a future release and to request the ability to modify the domain list in CPB so you can add your own in the future.

    Regards,

    Doug

    Add comment
    10|10000 characters needed characters exceeded

  • Aug 11, 2017 at 10:06 AM

    Thanks Doug, now I'm clear. But can you guide me through below statement:

    "The email domains that can be successfully identified are hard-coded in the product"

    Can i get access to this list?


    Regards,
    Santosh G.

    Add comment
    10|10000 characters needed characters exceeded