I am currently using a Read Range activity to obtain a Datatable, however I must merge that datatable with another whose columns are all of type string. But I can’t do this as the datatypes are different. How can I change the data type of the datatable that I extract from excel so that I can merge it with the other datatable?
Hi @JavXult ,
Could you pls have view on the below balareva custom package which is having activity to change the column data type for datatable. Thanks.
Unfortunately I can’t install packages in my projects, anyway thanks for the option!
when a datatable contains data within a particular column, the datacolumn type cannot be changed.
In such a case we can do:
- add a helper column with the target datatype
- run a conversion and populate the helper column
- remove old datacolumn
- rename helper column
- move it to the origin position with e.g. the help of SetOrdinal method
But we also do have alternates e.g.
- Excel change cell formating for influencing the retrieved datacolumn type
- alternate datacolumn value updates as presented here:
How to Update Data Column Values of a Data Table | Community Blog
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.