I have two tables and I want to merge them into a single table to get all from the first table and the matched from the second table but the keys in both tables are mismatched and don't have the same datatype so I got "select columns of the same type to continue"!
Is there any workaround to merge two tables with different datatypes?
This problem occurs because the column in the first table has a different datatype (Text) that is not the same as the datatype of the corresponding column (Number) in the second table! So I just changed the datatype of the second column to text.
But the matched row is now ZERO because the first column appends an additional fixed text at the beginning of each number, so I have solved this problem as the following:
Go to Query Editor and click on Add column Tab > select Custom Column .
Add the name of a column, add the custom formula.
> Number.ToText converts number to text.
Most popular tags