Group Data Table

Help Activities
, , , ,
1

Hello Team i have a query related to Excel i am having multiple data on a column so i want to pick only one from that multiple value and also unique value from them.

Thanks in Advance…

2

@Darkfighter,

You got two options here:

Method 1: Using DefaultView.ToTable

  1. Read Range: Use Read Range activity to read your Excel sheet into a DataTable, say yourDT.
  2. Assign Activity: Use the following LINQ query to filter out the distinct values:
yourDT = yourDT.DefaultView.ToTable(true, "ColumnName")

Method 2: Using LINQ and GroupBy

  1. Read Range: As before, use Read Range to load your Excel data into a DataTable.
  2. Assign Activity: Assign a new DataTable with unique values:
yourDT = yourDT.AsEnumerable().GroupBy(Function(r) r.Field(Of String)("ColumnName")).Select(Function(g) g.First()).CopyToDataTable()

This method uses LINQ to group by the column values and selects the first unique occurrence.

LLM helped me to rephrase the answer but it’s validated by me

2 Likes
Forum Engagement Daily Reports
3

Hi @Darkfighter

Check below workflow modify accordingly:

This image shows a data table being built in an automation software with two columns, one for strings and one for integers, where the string column includes repeated entries. (Captioned by AI)
This image shows a data table being built in an automation software with two columns, one for strings and one for integers, where the string column includes repeated entries. (Captioned by AI)950×372 21.5 KB

The image shows a UiPath workflow where the Expression Editor is used to assign a filtered DataTable to a variable named DTFilter by grouping and selecting values based on "Column1." (Captioned by AI)
The image shows a UiPath workflow where the Expression Editor is used to assign a filtered DataTable to a variable named DTFilter by grouping and selecting values based on "Column1." (Captioned by AI)824×199 22.9 KB

The image shows an output panel from a debugging session in UiPath, displaying the contents of a data table with columns "Column1" and "Column2". (Captioned by AI)
The image shows an output panel from a debugging session in UiPath, displaying the contents of a data table with columns "Column1" and "Column2". (Captioned by AI)673×530 21.4 KB

Happy Automation!

Group datatble, Extract Unique First Value from a Column with Multiple Comma-Separated Values
4

Hey @prashant1603765 thanks for the detailed steps.it really helped me out. :victory_hand:

1 Like
5

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.