8 Replies Latest reply: May 26, 2017 6:50 AM by Yeo Poh sai RSS

    How to clean my data , when company have 2 different name ?

    Yeo Poh sai

      Hi All

       

      My raw data for company in 1997 and 1998 , the company name was

       

      AT MECHATRONICS P L

       

      After year 19999 , the name change to below

      AT MECHATRONICS PTE LTD

       

      May i know what it the best way to solve this issue ? So that both company name will be same.

       

      Hope some one can suggest the best approach.

      company with 2 name.png