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:
- Add a new column in the first table.
Go to Query Editor and click on Add column Tab > select Custom Column .
Add the name of a column, add the custom formula.
"tt"&Number.ToText([IMDB ID])
> Number.ToText converts number to text.
- Now the error is gone and I can merge two tables
See Also