Normalise multiple records of same file



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

Normalise multiple records of same file

Postby anirban85 » Sun Oct 13, 2013 8:26 pm

Hi,

I am trying to normalize a flat file which has the below records -

12345 ANIRBAN IND
12345 ANIRBAN 176213
12345 ANIRBAN 18121985

I want the output file to look like -

12345 ANIRBAN IND 176213 18121985

Can you please help with the sort-card?
anirban85
 
Posts: 3
Joined: Sun Oct 13, 2013 8:17 pm
Has thanked: 0 time
Been thanked: 0 time

Re: Normalise multiple records of same file

 

Re: Normalise multiple records of same file

Postby NicC » Mon Oct 14, 2013 3:30 pm

You are merging records on a key - have you tried looking at the RESIZE option?
The problem I have is that people can explain things quickly but I can only comprehend slowly.
Regards
Nic
NicC
Global moderator
 
Posts: 2690
Joined: Sun Jul 04, 2010 12:13 am
Location: Pushing up the daisys (almost)
Has thanked: 4 times
Been thanked: 105 times

Re: Normalise multiple records of same file

Postby anirban85 » Mon Oct 14, 2013 4:40 pm

We cannot use RESIZE option.
anirban85
 
Posts: 3
Joined: Sun Oct 13, 2013 8:17 pm
Has thanked: 0 time
Been thanked: 0 time

Re: Normalise multiple records of same file

Postby BillyBoyo » Mon Oct 14, 2013 5:55 pm

Because?

You can try to apply this one: dfsort-icetool-icegener/topic9498-10.html#p47015
BillyBoyo
Global moderator
 
Posts: 3804
Joined: Tue Jan 25, 2011 12:02 am
Has thanked: 22 times
Been thanked: 264 times

Re: Normalise multiple records of same file

Postby anirban85 » Mon Oct 14, 2013 6:05 pm

i want to format the data, the data looks like this -

12345 date1 var1 date2
12345 date1 var2 date2
12345 date1 var3 date2

i want the data to look like -

12345 date1 var1 var2 var3 date2
anirban85
 
Posts: 3
Joined: Sun Oct 13, 2013 8:17 pm
Has thanked: 0 time
Been thanked: 0 time

Re: Normalise multiple records of same file

Postby BillyBoyo » Mon Oct 14, 2013 6:22 pm

Which you can make that example do.
BillyBoyo
Global moderator
 
Posts: 3804
Joined: Tue Jan 25, 2011 12:02 am
Has thanked: 22 times
Been thanked: 264 times

Re: Normalise multiple records of same file

Postby dick scherrer » Tue Oct 15, 2013 6:54 pm

Hello and welcome to the forum,

What might be the next addition to the scope? Your 2 sets of "input" are not the same. . .

Whwere are you stuck? Post what you have tried (jcl and sort control statements) from the link BB provided and explain where there is a problem.
Hope this helps,
d.sch.
User avatar
dick scherrer
Global moderator
 
Posts: 6304
Joined: Sat Jun 09, 2007 8:58 am
Has thanked: 3 times
Been thanked: 91 times


Return to DFSORT/ICETOOL/ICEGENER

 


  • Related topics
    Replies
    Views
    Last post