Every employee has 3-5 records and each record consists of company Id it may be 7826 in some records and 7827 in some records for the same employee ID, or it may be 7826 for some records and 7828 for some records for the other same employee ID. Based on the company ID's I am getting in the records say 7826 in some and 7827 in some records, so I convert 7826 to 7827 and then pass it to the output. Similarly if I am getting 7826 in some records and 7828 in some records for the other same employee ID then I convert 7826 to 7828 and then pass further. Kindly help me with the problem.
Thanks in advance,