Merged Tables

[Anonymous]

I attempted to merge two tables one from an excel spreadsheet & the other from an SQL table. To do this I created a thrid table with the columns that I needed from both tables.

The excel spreadsheet will contain updates on training completions using a learner's email, training name & status. When I added an additional rows to my excel spreadsheet it updated the table but not as I would have expected in the merged table. 

For example I have a learner in the table twice & it updated both records & ignored the training name. I believe becuase the merge is set to email that it updated them both. I tried to set it 1st to email & 2nd to training name but that created more issue.

I thought also maybe the relationship between the table is not correct being email to email (many to single). Any assistance will be appreciated. Thanks 

[lbendlin]

Ideally you should not use merges in Power Query. They are very costly.  See if you can use the data model joins instead.