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
123 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,090 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,930 points
2,416 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
403 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,930 points
2,143 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,930 points
1,609 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,930 points
860 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,090 points
2,698 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
8,187 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,090 points
5,581 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,090 points
2,046 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,090 points
2,920 views