Change entire column datatype

[KarthikBallary]

Hi
I have column which contains values like $1000,$2000,$3000 etc.
I need to change this entire column to integer. How Do I change this with single syantax without using for each row. I tried with cloning

[Pratik_Wavhal]

Hi @KarthikBallary

der is one activity by @balupad14
Change Cell Type Activity

You can use that activity for the same

Changing excel cell format with UiPath

Hi @cscrpa002, Check this video… [UiPath | How to change the cell or column format in Excel | Guide (datatype)] Thank you Balamurugan.S

Mark as solution and like it

Happy Automation

Best Regards
Er Pratik Wavhal

[Codegias (Mohammad Shah Faizal)]

if data is already in data table then you cannot, only option is to use a new Dt. If you are reading from excel source the use @Pratik_Wavhal’s approach

[supermanPunch (Arpan)]

@KarthikBallary You can try this Activity :

UiPath Marketplace | Error

[KarthikBallary]

Hi I have used Data clone…but
Dt.columns(“columnname”)=Get(System.int32) //here can we try regex?

while importing row to new DT it will throw error

[balupad14 (Balamurugan)]

Hi,
Here is the activity Change Column DataType for multiple column.

UiPath Marketplace - BalaReva Easy Data Table Activities

Hi , I have uploaded a package called “Easy DataTable Activities” in UiPath Marketplace. The package contains the below activities. Change Column Data Type - Change the datatype for DataTable by having the option to multiple columns Dictionary To DataTable - Convert the dictionary to DataTable Show DataTable - This activity helps to see the DataTable value and column information. Mainly this is testing DataTable value in the development stage. Here is the video explanation for the p…

Video demo :

UiPath datatable aggregation| change data type of data table| group by

Thank you
Balamurugan.S