Concatenate Value of 2 records

Ramco Ramco

I have below data . I have group by itemcode,batch no, warehouse. . In below case Batch no 4330 has 2 records with 2 Bin No I want to concat these 2 records.

Item Code	Batch No	Bin No	Warehouse Code
8	4330	242	82
8	4330	194	82
8	6527	194	82
8	6527	242	82
8	6648	242	82
8	7444	242	82
8	8567	242	82
8	8987	242	82
8	9743	242	82

It should display like this

4330

242,194

6527

194,242

Thanks

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Muhammad Imran Ansari1y ago
Hello Ramco,

In SQL, you can use the STRING_AGG function (in SQL Server 2017+) to concatenate the "Bin No" values for each group. Below is the examples:
```
SELECT 
    Item_Code,
    Batch_No,
    Warehouse_Code,
    STRING_AGG(Bin_No, ',') AS Bin_No
FROM 
    your_table
GROUP BY 
    Item_Code,
    Batch_No,
    Warehouse_Code
ORDER BY 
    Item_Code, Batch_No;
```
Good Luck!
Eliana Blake1y ago
Based on the data provided, it seems like you are looking to concatenate the Bin No values for records with the same Item Code, Batch No, and Warehouse Code. This can be achieved through SQL queries using GROUP BY and STRING_AGG functions in databases like SQL Server.

Here's an example of how you can concatenate the Bin No values based on your sample data:
```
SELECT [Item Code], [Batch No], STRING_AGG([Bin No], ',') AS ConcatenatedBins, [Warehouse Code]
FROM YourTableName
GROUP BY [Item Code], [Batch No], [Warehouse Code]
```
This query will group the records by Item Code, Batch No, and Warehouse Code while concatenating the Bin No values separated by a comma.

By running this query on your dataset, you should get the desired output where the Bin No values are concatenated for records sharing the same Item Code, Batch No, and Warehouse Code.

If you need further assistance or have a different database system in mind, feel free to provide more details for a more tailored solution.