Power Query Recon Question

[Koli]

Hello,

I hope all is well.  Could someone please assist with this request?  I am trying to recon 2 datasets in Power Query by merging and showing a Draft Recon tab.  I am running into a grouping and duplication issues. When I try to add in the material name, material number, ship to number and invoice numbers, from the Pay tab, my numbers are skewed, almost like they duplicated.  On the recon tab, I am trying to show those specific pay details along with the variances and qty information.  Please dropbox see link below:

https://www.dropbox.com/scl/fi/ysokt4hs0yyds8yadl9o0/Book1-061324.xlsx?rlkey=wvwtlk7okz8a62pnyxb7rjh...

Thank you!

[Anonymous]

Hi @Koli 

Based on your description, can you provide some sample output you want so that can provide more information for you.

Best Regards!

Yolo Zhu

[Koli]

Hello, 

Oh, I just re-read the post.  The output should be listed below along with the material name, material number, ship to number and invoice numbers from the Pay tab.

[Koli]

Hello Yolo,

I provided a dropbox link in the initial email.  Please see below link:

https://www.dropbox.com/scl/fi/ysokt4hs0yyds8yadl9o0/Book1-061324.xlsx?rlkey=wvwtlk7okz8a62pnyxb7rjh...

Thank you!