Page 1 of 1

Removing Duplicates using ICETOOL

PostPosted: Wed May 02, 2018 4:15 pm
by Papya013
Hi Team,

As per one of my business requirement data looks as mentioned below.

1234 BALU 00000
1234 RAVI  98767
1234 GANI 00000
3456 SURI 67859
9876 BALT 98767


I would like to perform delete on the last field (last 5 bytes).

Here according to the data 1st record and 3rd records are having the same data in the last 5 bytes as 00000 which is considered as duplicate.
Also 2nd and 5th record are having the same data in the last 5 bytes as 98767 which is considered as duplicate.

However, as per the requirement I would like to consider only the last 5 bytes for duplicate issue if the data is not equal to 00000.

Could you please help me with this.

Regards,
Balesh GG