Hi,
Thanks for the inputs the issue is resolved now …following the steps above updating the existing Datatable column values without creating new Datatable. Used Invoke Code activity to call the below code, Also referred the below link:
DataTable.AsEnumerable().ToList().ForEach(Sub (r) r.SetField(Of String)(“Amount”, CStr(r.Item(3)).Split("."c)(0)))