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

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.

2 Likes
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

Convert datatable general value to number
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.