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.
![change data type](https://debug.to/?qa=blob&qa_blobid=15163839300435318048)
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 .
![Create a custom column in Power Query](https://debug.to/?qa=blob&qa_blobid=16114532819779511582)
Add the name of a column, add the custom formula.
"tt"&Number.ToText([IMDB ID])
![Number.ToText formula in Power Query](https://debug.to/?qa=blob&qa_blobid=9955119630991021989)
> Number.ToText converts number to text.
- Now the error is gone and I can merge two tables
![Merge two tables](https://debug.to/?qa=blob&qa_blobid=11345161600229408671)
See Also