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

0 votes
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?
Oct 24, 2019 in RPA by Pratibha
• 3,690 points
258 views

1 answer to this question.

+1 vote

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.

answered Oct 24, 2019 by Anvi
• 14,150 points

Related Questions In RPA

0 votes
1 answer

Which system variable can be used for reading data from CSV/text file in Automation Anywhere?

Hello, FileData Column(col_name) is the system variable which ...READ MORE

answered Oct 17, 2019 in RPA by Abha
• 28,060 points
4,532 views
0 votes
1 answer

What are the file types supported by IQ bots?

Hi Rashmi, that's a very good question. ...READ MORE

answered Mar 7, 2019 in RPA by Pratibha
• 3,690 points
836 views
0 votes
1 answer

how get the specific data from an excel and write in another excel file in uipath?

@Renuka, I agree with your approach. You ...READ MORE

answered Aug 19, 2019 in RPA by Abha
• 28,060 points
2,972 views
0 votes
1 answer

How to extract table and text from pdf file and load into Excel by using workbench commands in automation anywhere

Hey Dhruv, to extract table and text ...READ MORE

answered Oct 10, 2019 in RPA by Abha
• 28,060 points
2,835 views
0 votes
1 answer

What is Get Jobs activity used for in UiPath Studio?

Hey @Rakesh, Get Jobs Activity can be ...READ MORE

answered Mar 14, 2019 in RPA by Abha
• 28,060 points
1,530 views
0 votes
1 answer

How to format text in notepad using UiPath?

Hey @Rashmi, if you want to automate ...READ MORE

answered Mar 18, 2019 in RPA by Anvi
• 14,150 points
4,696 views
+2 votes
1 answer

How can I display current date in "dd-MMM-yy" format in UiPath Studio?

Hi Shilpa, if you want to display ...READ MORE

answered Mar 18, 2019 in RPA by Pratibha
• 3,690 points
12,471 views
0 votes
1 answer

How to check if a string exists in datatable using UiPath?

Hi @Ravi, to check whether a string ...READ MORE

answered Mar 19, 2019 in RPA by Anvi
• 14,150 points
10,183 views
0 votes
1 answer

What are the different types of data items provided by blueprism?

Hey Apeksha, BluePrism provides following types of ...READ MORE

answered Oct 22, 2019 in RPA by Anvi
• 14,150 points
5,092 views
0 votes
1 answer

Modify CSV file using UiPath

Hi @Praharsh, You can add columns to an ...READ MORE

answered Mar 5, 2019 in RPA by Anvi
• 14,150 points
4,723 views