Power Query merge problems

[ben_sorensen]

Hi I am performing a merge in Power Query it has 79,815 lines. I have performed 3 merges so far no problem but then this last merge all the sudden turns the data set into 44,512 lines of data. By the way the merge file is a simple lookup of 9 lines.

i can’t figure out why on earth one merge is cutting the data in almost half. Any insights would be appreciated.

 

[horseyride]

post the code and data sample