Error while merging two tables - Need a solution?

[Ishi_garg]

I have to merge two tables that have a common column as Country-ID. I tried merging them by keeping the data type of the common column in both the tables, first as Whole Number and then as Text, but neither of them is working.  I am getting the following error.  

[v-juanli-msft · Accepted solution]

Hi @Ishi_garg 

When Merging tables, it doesn't support to merge based on columns which have two kinds of data types.

Please change the type to the same one.

If you need to keep, you could create a duplicate column for that column, and change the type.

Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

dd

[Jimmy801]

Hello

Are you reading data from a Excel workbook? It is possible that in one of your cells it's a formula error?

Hope this helps

Jimmy