Creating data scraping workflow which saves the data into csv file by sort

Question

Hey! Im making workflow to find stuff from amazon.com and then save it by ascending alphabet order to csv file and other option is save by ascending price. Please suggest what would be the best way to do this?

Answer 1

Hi @Pratibha, try using following method to sort your datatable after reading the excel file: 

sortedDT = yourdt.AsEnumerable().Orderby(Function(a) a.Field(of string)(“ColumnName”).ToString).CopyToDatatable()

And then use Write Range activity to write into excel file and pass that DataTable.