Skip to Content

How to group common Firm names in Data Services?

Hi Team,

I have Firms names like as below,

CVV Solution Ltd

CVV Sol

CVV Ltd

How to group all CVV firm names to CVV Solution Ltd in another separate column,

CVV Solution Ltd

CVV Solution Ltd

CVV Solution Ltd

please share needful information.

Thanks,

Chandrasekhar .K

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Dec 13, 2017 at 10:46 AM

    Hello,

    We have SAP Information steward Data cleansing packages. where You can create a package and you have to specify variations and a standard form. Variations will be CVV Solution Ltd, CVV Sol, CVV Ltd and Standard form will be CVV Solution Ltd. Suppose if you get new variations again like CVV Sol Lt then you have edit the cleansing package and this in variations. or you can add all possible variations before hand while developing only. or You can create a table with 2 colums Variations and standard and add like below and join with this table and map standard column to the output.

    Variations Standard

    CVV Solution Ltd CVV Solution Ltd

    CVV Sol CVV Solution Ltd

    CVV Ltd CVV Solution Ltd

    Add comment
    10|10000 characters needed characters exceeded

    • Thanks Ravi for the response.

      I have created a Data Cleansing and Firm names as below,

      Note: I marked results are the firm names, here In 1st column as different variations of the firm names and 2nd column group is starting with "Berg" firm names.

      I published Data Cleansing to Data Services and In output not shows NAME1 field name.

      How to show NAME1 field data in Data Services

      iss.png (50.6 kB)