Forum Discussion

gidon's avatar
gidon
Helper II
9 years ago
Solved

Reduce data

Hello   when I load a table I want to reduce Part Numbers according to falg given on differnt table this ia my data  and reduce flag table I want to load only parts with Reduce = 'n' ( this tab...
  • Greg_Deckler's avatar
    Greg_Deckler
    9 years ago

    In Power Query editor (Edit Queries), select your main query. Go to the last step in that query. All the way to the right you should see "Merge Queries". Click that. It will bring up a dialog allowing you to select the common columns and pick what kind of join you want.