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

Help
1

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. 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)

2

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

Th@nks
@shwin S

3

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

4

@Darba

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
5

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
6

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