Re: Concatenating rows based on certain conditions?
Very impressive the way you did it. Its very close to what I wanted .
Is it possible to display 1205 ( see fig above) as a separate record ( I have circled it in red in the fig above) for record 1200590.(note 1200590 should appear twice in the table one record for 1205 series and one for 1305 series...so on )
My requirement is values starting 1205..to 12012 in NOTE_SEQ must appear as one record for claim number 1200590 (circled in green)
and values starting 1305..to 13012 in NOTE_SEQ must appear as another record for claim number 1200590 (circled in green)
Is it possible to make 1200590 appear twice in the table ie one record for 1205 and the other for concatenated 1305,1306,1307.(note in the snap I have attached above I have circled the number in red)