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:
Referred the below link, which needs iteration of the entire Datatable to change the values:
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