create a comma-separated string from multiple rows

user09445

If you think of it, it's basically reverse engineer the process of "splitting a string into multiple rows".

I have a long list of values that are already split into different rows from the original data source, but now I want to put them back in a single string, separated by the commas.

How do I do that? my data is relatively large. 

sample of original data source:

customers_id	carrier_requested
342062	UPS WSV
342062	UPS GD
342062	UPS 3D
194343	UPS ST
194343	UPS SP1
194343	UPS WXP

 sample of ideal output:

customers_id	carrier_requested
342062	UPS WSV, UPS GD, UPS 3D
194343	UPS ST, UPS SP1, UPS WXP

BlueRooster

So you'll need to use a SQL transform for your dataset.

 

It would go something like this:

SELECT `customers_id`, GROUP_CONCAT(`carrier_requested` SEPARATOR ', ') as 'carrier_requested'
FROM data_source
GROUP BY `customers_id`

The MySQL GROUP_CONCAT function looks like what you'd want to use.

 

Hope this helps,

ValiantSpur

 

**Please mark "Accept as Solution" if this post solves your problem
**Say "Thanks" by clicking the "heart" in the post that helped you.