Create a new line when a value changes in data



Support for NetApp SyncSort for z/OS, Visual SyncSort, SYNCINIT, SYNCLIST and SYNCTOOL

Create a new line when a value changes in data

Postby speermb » Fri May 17, 2019 9:20 pm

I have a file that contains details and id - when then id changes I want a different output line. Is this possible?

Iput looks like below

id        details
10       detail 1
10       detail 2
10       detail 3
10       detail 4
11       detail 1
11       detail 2
12       detail 99
12       detail 1        
 

Desired output is

For Id 10 we have:       Detail 1
                                  detail 2
                                  detail 3
                                  detail 4
For Id 11 we have:      Detail 1
                                 detail 2
For Id 12 we have:      Detail 1
                                 detail 99
 
speermb
 
Posts: 7
Joined: Thu Nov 05, 2009 9:01 pm
Has thanked: 0 time
Been thanked: 0 time

Re: Create a new line when a value changes in data

 

Return to Syncsort/Synctool

 


  • Related topics
    Replies
    Views
    Last post