I have a Sequential File with RECFM=FB, LRECL = 1000. File has Multiple Set of Records.My Requirement is, I want to concatenate all Records where Record starting from Position 1 To 14 Having same value. All Records where Starting 14 Bytes are same, should Apprear Once & Remaning fileds should get Concatenated & Written to Ouput File, If there is a Single Occurence of Record should get written as-is. Attribute of Output File: LRECL = 2000, RECFM = FB. Below is Example:INPUT FILE:123 ABC XYZ123 DBA DB2 MF123 ABC XYZ123 ORA JOB KF999 XYZ XYZ123 CAT JOB AF888 kBC ABC123 MAT MAN NF123 ABC XYZ123 DIG CAL BC888 kBC ABC123 PAN MAL KKOUTPUT FILE:123 ABC XYZ123 DBA DB2 MF ORA JOB KF DIG CAL BC - Pipe( ) After MF,KF.3 Instance Of Record. Here123 ABC XYZ123 is Common in all Records.888 kBC ABC123 MAT MAN NF PAN MAL KK - Pipe( ) After NF.2 Instance Of Record.
![Concatenate Concatenate](/uploads/1/2/5/6/125618595/306375617.gif)
![Concatenate Multiple Records Dfsort Concatenate Multiple Records Dfsort](http://lh3.ggpht.com/_sQvdFWqMlMg/SnhOR4ebO9I/AAAAAAAABIA/sk1LAxlPS_E/s800/DFSORT%20Introduction.png)
Hello, I am trying to combine multiple rows into a single row in Excel. Here is my data - Column A has multiple rows with the same value and I want to combine those rows into one row. 617 R1 4.75 0.
Here888 kBC ABC123 is Common in all Records.999 XYZ XYZ123 CAT JOB AF - Single Instance of Record.Note: While Concatenating Files Pipe Symbol ( ) to Be Appended after end of each Record if we have Multiple Instance of Records. If Single Instance Then Record Should be Printed without Pipe Symbol ( ).ThanksKind RgdsVineet Anand Posts: 86 Joined: Tue Jun 19, 2007 11:38 am Has thanked: 0 time Been thanked: 0 time. Hi SKOLUSU,Below is the Reply to UR Queries.1.What is the maximum number of duplicates you can have per each key?Maximum Duplicate (14 Bytes, Starting form Position 1 To Position 14) we can have is 3. If we have a Single Instance ofRecord i.e.
No Duplicate then Record to be printed as It is & remaning should be Spaces. Similarly if we have 2 Instance ofDuplicate then after concatinating Remaning Fields to be Space filled.2.What is the length of the field to be concatenated?
(ex: DBA DB2 MF, ORA JOB KF.)For INput LRECL = 500 & For Output File LRECL = 1500.I hope I am Clear. If any Clarification Required do let me know.ThanksKind RgdsVineet Posts: 86 Joined: Tue Jun 19, 2007 11:38 am Has thanked: 0 time Been thanked: 0 time.
ICETOOL has an option RESIZE which is helpful when we want to create large record (single row) by combining multiple rows.