cpuhawg
Active User
Joined: 14 Jun 2006
Posts: 281
Location: Jacksonville, FL
|
|
|
|
I have a requirement to combine many records in to a single record. I know I can SPLICE the 10 files two by two, but would like to be able to accomplish this in one step, if possible.
Input view FB/30/27990:
| Code: |
----+----1----+----2----+----3
HLQUAL1 A
HLQUAL1 B
HLQUAL1 C
HLQUAL1 F
HLQUAL1 L
HLQUAL1 N
HLQUAL1 R
HLQUAL1 T
HLQUAL1 U
HLQUAL1 V
HLQUAL2 A
HLQUAL2 B
HLQUAL2 F
HLQUAL2 L
HLQUAL2 R
HLQUAL2 T
HLQUAL2 V
HLQUAL3 A
HLQUAL4 T
HLQUAL4 U
HLQUAL4 V
|
Output should look like:
| Code: |
----+----1----+----2----+----3
HLQUAL1 A B C F L N R T U V
HLQUAL2 A B F L R T V
HLQUAL3 A
HLQUAL4 T U V
|
Any assistance would be appreciated. |
|
