Repeating unique id for next particular set of rows

lagneshp · New User Joined: 15 Aug 2009 Posts: 29 Location: Chennai

Hi

My Input looks like:

Skolusu · Posted: Thu Oct 03, 2013 4:48 am

Look at the smart DFSORT trick "Include or omit groups of records" to use WHEN=GROUP and remove the INCLUDE on OUTFIL and use BUILD to get the required output.

www.ibm.com/support/docview.wss?rs=114&uid=isg3T7000094

lagneshp · New User Joined: 15 Aug 2009 Posts: 29 Location: Chennai

Thank you Skolusu...

I used below sort card

SORT FIELDS=COPY
INREC IFTHEN=(WHEN=GROUP,BEGIN=(12,1,CH,NE,C' '),
PUSH=(283:ID=8))
OUTREC BUILD=(1,290)

It worked well.

Thanks,
Lagnesh.

Bill Woodger · Posted: Sat Oct 05, 2013 4:49 am

Thanks for letting us know and showing what you used.

What happened when you run your sample input? Don't you need to do something with the blank lines?

If you actually only have four records in each group, for certain, you can also consider RECORDS=4 on the WHEN=GROUP, which will leave the blank lines (if there are any) undisturbed.