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 in RPA by Pratibha
• 3,680 points
37 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 by Anvi
• 13,960 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 in RPA by Abha
• 27,180 points
137 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 in RPA by Pratibha
• 3,680 points
125 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 in RPA by Abha
• 27,180 points
365 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 in RPA by Abha
• 27,180 points
113 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 in RPA by Abha
• 27,180 points
399 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 in RPA by Anvi
• 13,960 points
1,186 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 in RPA by Pratibha
• 3,680 points
3,845 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 in RPA by Anvi
• 13,960 points
2,456 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 in RPA by Anvi
• 13,960 points
35 views
0 votes
1 answer

Modify CSV file using UiPath

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

answered Mar 4 in RPA by Anvi
• 13,960 points
1,247 views