Grouping data with Count

Help Activities
, ,
3

Hi @craig.norton ,

You can use LINQ for this,

InputDt:

A data table displaying inventory items with corresponding quantities for the Brisbane branch, listing paper, pens, and markers. (Captioned by AI)
A data table displaying inventory items with corresponding quantities for the Brisbane branch, listing paper, pens, and markers. (Captioned by AI)758×532 16.8 KB

OutputDT:

The image shows a dark-themed "Build Data Table" window with columns labeled "Branch," "Item," and "Qty," each designated as a String type, along with options to add and remove rows and buttons for "OK" and "Cancel." (Captioned by AI)
The image shows a dark-themed "Build Data Table" window with columns labeled "Branch," "Item," and "Qty," each designated as a String type, along with options to add and remove rows and buttons for "OK" and "Cancel." (Captioned by AI)761×538 9.69 KB

Flow:

This image shows a data processing workflow in UiPath Studio, with steps to input and output data tables and an assignment operation to transform or filter the data. (Captioned by AI)
This image shows a data processing workflow in UiPath Studio, with steps to input and output data tables and an assignment operation to transform or filter the data. (Captioned by AI)747×452 9.94 KB

Linq query:

(From row In Input_DT.AsEnumerable()
          Group row By branch = row("Branch").ToString.Trim, item = row("Item").ToString.Trim Into Group
          Select Output_DT.Rows.Add(branch, item, Group.Count())).CopyToDataTable()

Output:

The image shows a JSON array containing three objects, each listing items (Paper, Pens, Marker) and quantities available at the Brisbane branch. (Captioned by AI)
The image shows a JSON array containing three objects, each listing items (Paper, Pens, Marker) and quantities available at the Brisbane branch. (Captioned by AI)437×506 5.57 KB

Regards,
Vinit Mhatre