Sort datatable data based on one column

clumsily · August 14, 2021, 1:32pm

Example: I have a csv file like this.

Name,Price,Brand
iphone1,2000,apple
galaxy1,2040,samsung
iphone2,3000,apple
mate1,3020,huawei

I want to order it by the brand so it looks like this:
Brand,Name,Price
apple iphone1,2000
iphone2,3000
samsung galaxy1,2040
huawei mate1,3020

what activity do i use and how?

NIVED_NAMBIAR · August 14, 2021, 6:54pm

Hi @clumsily
did u need end result like this

Then check this sample flow
Main.xaml (9.9 KB)

Regards,
Nived N

Kenneth_Balana · August 14, 2021, 7:40pm

Hi @clumsily,

You can use Sort Data Table Activity for this.

It is located under the Programming>DataTable categories from Activity Panel.

Step1: To perform the sorting process under your data table (not sorted) place Sort DataTable and indicate the Input DataTable you want to sort.
Eg: dt1

Step2: Next, create a Data Table variable that stores the Sorted DT.
Eg: dt2

Step3: Under the Sorting Column there are several ways to locate which column you want the sort to perform.

Try using the third one which is “Name” and Input “Name” (the column from your table).

For the Output I used Write Range and send the sorted table as the input.

RESULT:

Happy Automation,
Ken

kumar.varun2 · August 15, 2021, 2:48am

Hi @clumsily

Another way to achieve the same.

dt.AsEnumerable.OrderBy(Function (r) r("Brand").ToString).CopyToDataTable.DefaultView.ToTable(False, {"Brand", "Name", "Price"})

Finally you can write dt in excel file using Write Range

jeevith · August 15, 2021, 6:56am

Hi @clumsily,

I think you are looking for a Groupby not Sort.

Groupby on Brand column.

@Kenneth_Balana, @kumar.varun2 may be you can assist with Groupby as well.

Kenneth_Balana · August 15, 2021, 10:30am

GroupBy: Display the name of the item of each Brand.

Let:
dtBrand as DataTable output from read range activity
item as “Brand” as the key and
row as the data row value from each brand.

First For Each:
Using For each activity with Argument Type IGrouping: key of string and element of data row.

Set the values property with:
dtBrand.AsEnumerable().GroupBy(Function (li) li.Field(Of String)("Brand"))