Unable to Truncate decimal places from decimal values of a column in Datatable

[mailsmithash (Smitha)]

Hi, There is a Datatable which has column values as decimal numbers, need to truncate the decimal values and maintain only the whole number.I do not want to round of the values but just maintain the whole number and remove the decimal places:

Example: 888967.73 to be converted to 888967

Trying to use the below and assigning it back to dptDT Datatable, but it doesn’t seem to be truncating the decimal places:

dptDT.AsEnumerable().OrderBy(Function® Convert.ToString(r(“Amount”).ToString.Split("."c)(0))).ToArray().CopyToDataTable()

Referred the below link, which needs iteration of the entire Datatable to change the values:

Round of values in datatable

In datatable I have one column in which there are many values like 5.502333 etc… I just want to take round of value like 5.50 till two digit … how I can apply for all values in datatable… Need ur Help!!

There are around 4000 rows in the Excel sheet, and iterating and truncating is taking a long time in executing the workflow.

Is there anyway to convert all the column values in one single query on the Datatable. Please let me know

[mailsmithash (Smitha)]

Followed the below link as well to use LINQ query for updating Column values of a Datatable

Two.5 Questions both relating to Datatables and making updates (hopefully) without For Each Loop

Maybe this could be achieved using a LINQ expression. This may help you Cheers

getting this error even after adding the DataSetExtensions following the link

'CopyToDatatable' is not a member of 'System.Array'

@itmonster999 Follow below link it might help you. You can also try like this. Go to Import, Import the below reference System.Data.DataSetExtensions Regards, Mahesh

[J0ska]

You will need to copy from one DT to another like follows:

dt2 = (From row In dt1.AsEnumerable
Select dt2.rows.Add(CStr(row.Item(0)).Split("."c)(0))).copytodatatable

Cheers

[mailsmithash (Smitha)]

Thanks will try that

[mailsmithash (Smitha)]

@J0ska

(From row In dt1.AsEnumerable
Select dt2.rows.Add(CStr(row.Item(0)).Split("."c)(0))).copytodatatable

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 column update using Foreach in lambda expression is throwing an error

@mbalaji1985 Have a look on edited XAML here: mbalaji1985_II.xaml (7.7 KB) please crosscheck the formats e.g. day and month are in the right order Date conversion were finally done with: r.SetField(Of String)(“Start time”,Date.ParseExact(r(“Start time”).ToString(),“M/d/yyyy hh:mm:ss tt”, CultureInfo.InvariantCulture).ToString(“M/d/yyyy”)

DataTable.AsEnumerable().ToList().ForEach(Sub ® r.SetField(Of String)(“Amount”, CStr(r.Item(3)).Split("."c)(0)))