Concatenate the Results

[codrutza]

SAP CR2003

Hello

eg I have 4 records in the result:
1.Cont.NumberX
2.Cont.UnitA
3.Cont.UnitB
4.Cont.UnitC

and I need the result in a record:
1.Cont.NumberX 2. Cont.UnitA +' '+Cont.UnitB +' '+Cont.UnitC
where 2 = a field


Please help.

 

[lbass]

Are you saying that the first value is a different field from the last three?

Are the numbers coming from a separate field? If not, how did you create these?

Please name your fields.

-LB

 

[codrutza]

The table is Containers.

Few records are:
JobNumber ContainerNumber
1120339
1120339 TTNU2499140
1
1120423
1120423 ICUU9601717
1120423 ICUU9606365
1120423 CAIU4202803
3
1121260
1121260 MRKU5429434
1121260 MSKU8439227
2
1121739
1121739 HASU5138730
1121739 SUDU6551036
1121739 TCKU6954748
3
1122120
1122120 BMOU5209799
1122120 EGHU9075810
2
1123068
1123068 EISU9206775
1

I made a group by jobnumber, and I count the containers in it, to have an image.

The desired result:

1120339 TTNU2499140
1120423 ICUU9601717+' '+ ICUU9606365+' '+ CAIU4202803
1121260 MRKU5429434+' '+ MSKU8439227
1121739 HASU5138730+' '+ SUDU6551036+' '+ TCKU6954748
1122120 BMOU5209799+' '+ EGHU9075810
1123068 EISU9206775

 

[lbass]

Do you really mean that you want the viewer to see your ‘+’ signs and your ‘“ “” for spaces? Why? Or are you just telling me you want a space between the codes?

-Lb