Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.
Solved! Go to 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
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