Forum Discussion

Ishi_garg's avatar
Ishi_garg
New Member
6 years ago
Solved

Error while merging two tables - Need a solution?

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 ...
Need Help
Show and Tell
Tutorial Requests
  • v-juanli-msft's avatar
    v-juanli-msft
    6 years ago

    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

v-juanli-msft's avatar
v-juanli-msft
Community Support
6 years ago

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