for example
loop through the datatable check if condition for example if the column value greater the 10 means the current row value is write into the excel if not the row value is write it to the another sheet of same excel
I want to know that if i use get row item activity then i will get the value of a particular column only. If i want to extract the data of whole row whole amount>200.Then what should i do??
Something like add data row could work ?
use something like this
SortedDebitTable=dtRange.Select(“C.D.Falg = ‘D’”).copytoDatatable Here C.D.Falg is a column name and it contains C,D etc but I want to filter based on D.
Based on this it will fetch all the values from that table matching with the condition
Hi @SHAISTA,
Use the below code to get the above 200 value from the datatable.
If you use this on no need to use for each row activity.using below code to get the filtered value. Dt=Dt.Select("[total amount]> 200").CopyToDataTable()
If you want to convert the column to int use below code Dt=Dt.Select("Convert([total amount],System.Int32)> 200").CopyToDataTable()
If suppose the total value is decimal value use below code Dt=Dt.Select("Convert([total amount],System.Decimal)> 200").CopyToDataTable()
After getting this value you can write it into excel sheet using write range activity.