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

Hey! Im making workflow to find stuff from and then save it by ascending alphabet order to csv file and other option is save by ascending price. This is what I got done so far but what I can do to get ascending order by price or alphabet starting name? Do I have to make excel application scope or what’s best method?
Amazonworkflow.xaml (13.4 KB)

Hi @Darba
try this
DataView view = new DataView(table)
DataTable distinctValues = view.ToTable(true, "Column1", "Column2" ...)

@shwin S

Hey, I tried work around that but got errors only.


Use below experience after reading that 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.

1 Like

Hey that worked, can I use keywords to sort by which are not column names? Or it has to be column name connected to something as example price to number prices, names to alphabetical order etc?

1 Like

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