Data table filtering


#1

… How to filter a data table . here i have column names like mobile,url,price stored in a .CSV file. in the assign activity im using code like this var=mobile.select(“price>10000”) but showing an error doesn’t performing > action as you can see in the image … can anyone look into this please


#2

hey @Harshavardhan

Try with this: var=mobile.select(“price>‘10000’”)


#3

it worked thanks @aksh1yadav . one more question how to write these output in to excel file ? here output is in the form to string how to covert it into data table ?


#4

Hello @Harshavardhan,

DataTable.Select method gets an array of all DataRow objects.

one possible solution would be to use the DataTable.ImportRow method to convert this array to datable:

https://msdn.microsoft.com/es-es/library/system.data.datatable.importrow(v=vs.110).aspx

Here is an example: ImportRow.zip (2.1 KB)

Regards,
Susana


Problems Adding/Removing Rows from DataTables
#5

How to get System.Data.DataRow[] array please show me