Change Data table column type String to Integer

Help Studio
, ,
1

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.

2

Hi @sankar.mayilsamy

Welcome to UiPath community

Have a look on the thread

Use Filter Data Table activity filter the Amount

https://docs.uipath.com/activities/docs/filter-data-table

Regards
Gokul

3

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:

CInt(CurrentRow(“originalcolumnname”).ToString)

You don’t need Balareva. These are all simple operations that are done with basic UiPath activities.

4

Thanks, I will try this method

5

Hi @sankar.mayilsamy

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)

Regards
Gokul

Regards
Gokul

6

Thanks for your support.

7

Have you tried with the XAML file. @sankar.mayilsamy

Have you got you required output?

Regards
Gokul

8

Hi Gokul,

I will try it tomorrow and let you know.

Regards,
Sankar M

9

Hi @sankar.mayilsamy

Welcome to UiPath Community !

Regards
Balamurugan.S

10

It is Working fine now, Thanks

11

Great @sankar.mayilsamy

Kindly close this topic by mark as solved

Regards
Gokul

12

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.