Forum Discussion
Power Query - Merge table do not search in the entire table.
Merge query has no such limitation. You must check whether those cells match or not.
You can do following to test.
Insert an Index in your lookup table.
Let's say your matched value is in row 15100 for which you are not getting result.
Apply a filter on Index for >15000. Now your looked value will be within 1000 rows limit which you are talking about.
So perform merge on this filtered table to establish whether values are matching or not and whether 1000 limit which you are talking about is correct or not.
Merge query has no such limitation. You must check whether those cells match or not.
You can do following to test.
Insert an Index in your lookup table.
Let's say your matched value is in row 15100 for which you are not getting result.
Apply a filter on Index for >15000. Now your looked value will be within 1000 rows limit which you are talking about.
So perform merge on this filtered table to establish whether values are matching or not and whether 1000 limit which you are talking about is correct or not.
you are right after reaching the data, and past it in notepad I figure out there is space behind it.
I beleived the "clean" function will prevent this kind of mistake, but it seems the "trim" function only work.
Thanks a lot.