Fetching the values associated with the Unique Column Value (Group by)

Help Studio
, , ,
1

Input:

Reservation ID Amount Code
NJMPDBHW 56 7992
NJMPDBHW 78 7991
NBPPBQFN 90 7992
NBPPBQFN 94 7991

Output

Reservation ID Amount Code
NJMPDBHW 56, 78 7992, 7991
NBPPBQFN 90, 94 7992, 7991

Reading_the_UniqueReservationIDs.xaml (36.3 KB)

2

Have a look here and get introduced into the different options:
[HowTo] Overview on different options for grouping data and processing the groups - News / Tutorials - UiPath Community Forum

1 Like
3

Hi @Nissy_Ruth_Prabhu

Can you try the below

This image is a flowchart of a process that reads data from "Sheet2" of an Excel workbook, assigns it to a variable "dt," and writes the data to the "Output" sheet of the same workbook. (Captioned by AI)
This image is a flowchart of a process that reads data from "Sheet2" of an Excel workbook, assigns it to a variable "dt," and writes the data to the "Output" sheet of the same workbook. (Captioned by AI)848×572 25.4 KB

Code:

(From row In dt.AsEnumerable()
                              Group row By ReservationID = row("Reservation ID") Into GroupedRows = Group
                              Let Amount = String.Join(", ", GroupedRows.Select(Function(r) r("Amount").ToString()))
                              Let Code = String.Join(", ", GroupedRows.Select(Function(r) r("Code").ToString()))
                              Select ReservationID, Amount, Code
                             ).ToList() _
                             .Select(Function(x) dt.Clone.Rows.Add(x.ReservationID, x.Amount, x.Code)).CopyToDataTable()

Input:

The image shows a spreadsheet with three columns titled "ReservationID," "Amount," and "Code," containing data for four reservations. (Captioned by AI)
The image shows a spreadsheet with three columns titled "ReservationID," "Amount," and "Code," containing data for four reservations. (Captioned by AI)589×393 5.93 KB

Output:

The image shows a spreadsheet with three columns labeled "Reservation ID," "Amount," and "Code," containing two rows of data with specific IDs, amounts, and codes. (Captioned by AI)
The image shows a spreadsheet with three columns labeled "Reservation ID," "Amount," and "Code," containing two rows of data with specific IDs, amounts, and codes. (Captioned by AI)486×339 4.74 KB

Regards,