Convert datatype of data table values

[_pjflo]

Hello!

Quick question. How to convert the variable type of the values of a data table? I’m having an issue when merging because of the conflict of data type.

Is it possible to convert the whole data table into an Object or String type using linq?

Thanks!

[fernando_zuluaga]

Hi @_pjflo

How about the following?

Convert the data type of column of datatable

Hi, I suppose type of Datacolumn is object if use ReadRange ativity… Anyway, we cannot change type of DataColumn if data already exists. The following sample is for create new datatable which has same name columns and expected data type. [img20211027-1] Sample20211027-1.zip (8.9 KB) If your datatable is very large, it might be better to write the above in InvokeCode. Regards,

Regards!

[postwick (Paul)]

Create new column with desired datatype. For Each Row in Datatable, update new column with correct values. Remove old column. Rename new column.

[_pjflo]

Thanks for your help!

[_pjflo]

Hi, thanks for your help!