Issue Merging Data Tables

[elliot.barling]

I am having an issue merging 2 data tables
I am getting the following error:
Merge Data Table: .Name and .Name have conflicting properties: DataType property mismatch.strong text

I understand this issue is caused by the columns having different data types in each data table but I am confused as to how to solve it

[sonaliaggarwal47 (Sonali Aggarwal)]

Hi @elliot.barling

Please consider changing the data type to a common data type before merging.

Refer below

Merge Data Table: <target>.Source File Name and <source>.Source File Name have conflicting properties: DataType property mismatch

I want to merge these two data tables but as you can see, their datatype mismatch. dt_Statistics comes from Read Range Workbook and containing only headers. dt_Report is datatable that I need to pass to dt_Statistics. In this case, I would prefer dt_Statistics to have String datatype. Is there any way to make sure the type is always String when being read? [image]