URGENT : Concatenate multiple records from table
I have multiple records in a table pertaining to a business key
ID Name Value
01 ABC 180
01 ABC 219
01 ABC 320
02 RAT 111
03 BAT 654
I want to extract this data into a file in this format:
ID Name Value
01 ABC 180, 219, 320
02 RAT 111
03 BAT 654
Basically concatenate the values of one field based on the business key (in above example its ID)
Please suggest the easiest way to get this done.
Thanks & Regards
|