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
58 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,010 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 16, 2019 in RPA by Abha
• 27,740 points
842 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
214 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
• 27,740 points
1,124 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
• 27,740 points
614 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 13, 2019 in RPA by Abha
• 27,740 points
538 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,010 points
1,468 views
+1 vote
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
5,255 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 18, 2019 in RPA by Anvi
• 14,010 points
3,402 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 21, 2019 in RPA by Anvi
• 14,010 points
394 views
0 votes
1 answer

Modify CSV file using UiPath

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

answered Mar 4, 2019 in RPA by Anvi
• 14,010 points
1,611 views