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
der is one activity by @balupad14
Change Cell Type Activity
You can use that activity for the same
Mark as solution and like it
Er Pratik Wavhal
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 :
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
Here is the activity Change Column DataType for multiple column.
Video demo :
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.