Forum Discussion

__BigDaddy's avatar
__BigDaddy
Frequent Visitor
4 years ago
Solved

Power Query - Merge table do not search in the entire table.

Hello,   After a long look at the web to find a solution.  I have a small article table (80 rows) and I'd like to enrich it with a big general article table (50 k rows) and send back the informa...
Need Help
  • Vijay_A_Verma's avatar
    Vijay_A_Verma
    4 years ago

    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.

Vijay_A_Verma's avatar
Vijay_A_Verma
Icon for Most Valuable Professional rankMost Valuable Professional
4 years ago

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.