Change entire column datatype

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

1 Like

Hi @KarthikBallary

der is one activity by @balupad14
Change Cell Type Activity
image

You can use that activity for the same

Mark as solution and like it :slight_smile:

Happy Automation :raised_hands:

Best Regards
Er Pratik Wavhal :robot::man_technologist:t4: :computer:

1 Like

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

@KarthikBallary You can try this Activity :

1 Like

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

1 Like

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

Video demo :

Thank you
Balamurugan.S

1 Like

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