Removing Duplicates using ICETOOL



IBM's flagship sort product DFSORT for sorting, merging, copying, data manipulation and reporting. Includes ICETOOL and ICEGENER

Removing Duplicates using ICETOOL

Postby Papya013 » Wed May 02, 2018 4:15 pm

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
Papya013
 
Posts: 35
Joined: Wed Nov 06, 2013 6:53 pm
Has thanked: 0 time
Been thanked: 0 time

Return to DFSORT/ICETOOL/ICEGENER

 


  • Related topics
    Replies
    Views
    Last post