on 12-13-2017 10:34 AM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
User | Count |
---|---|
82 | |
10 | |
10 | |
9 | |
6 | |
6 | |
5 | |
5 | |
4 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.