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
337 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,170 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,120 points
5,557 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
1,096 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,120 points
3,351 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,120 points
3,240 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,120 points
2,106 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,170 points
5,692 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
14,195 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,170 points
13,273 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,170 points
6,573 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,170 points
5,420 views
webinar REGISTER FOR FREE WEBINAR X
Send OTP
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP