Change entire column datatype

Learn
, ,
1

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
2

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
3

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

4

@KarthikBallary You can try this Activity :

1 Like
5

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
6

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

Video demo :

Thank you
Balamurugan.S

3 Likes
7

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