Data table => “Amount” column is String so how can i change String to integer data type and Need to Filter the amount. Please can you tell me with out BalaReva Excel Activities.
Welcome to UiPath community
Have a look on the thread
Use Filter Data Table activity filter the
Create a new integer column. For Each Row in Datatable to loop through the data and assign the new column to the converted int value of the original column:
You don’t need Balareva. These are all simple operations that are done with basic UiPath activities.
Thanks, I will try this method
How about this expression?
(From d In DtBuild.AsEnumerable Where CInt(d(1).toString.Trim)>=70 Select d).CopyToDataTable
Note → Need to give the Filter amount value instead of 70 in the expression
Check out the XAML file
ConertStringToInt.xaml (8.1 KB)
Thanks for your support.
Have you tried with the XAML file. @sankar.mayilsamy
Have you got you required output?
I will try it tomorrow and let you know.
Welcome to UiPath Community !
It is Working fine now, Thanks
Kindly close this topic by mark as solved
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.