Hi Everyone,
I have a report in hand called Published Price List. I need to compare the prices of this report against two other reports coming from UPC and PLM based on the Material #. The published Pricelist report is the main reference here.
PL has 2891 Unique Material's List
As a first step, I did a Join with PL (Price List) VS UPC Which compares 2867 Common Material, 24 material did not match from PL List.
Secondly, I did a PL VS PLM join Which compares 1716 common Material List and 1175 Materials from PL that didn't match.
Now, my goal is to reconcile all 2891 Materials available in PL along with the available PLM and UPC prices for the common Materials in the same row for each material.
The problem is when I do a union, I am getting duplicate. For example for MAterial #10000502 Initially there are two records that come in, on the first one it has all prices except the PLM one. And the second record for this 10000502 price list has PLM price lists but missing the UPC.
When I added a unique tool to remove the duplicates, it only takes the first one so when I am comparing PLM values are missing.
Can anyone please tell me what would be the best approach to this? Please let me know if you have any questions. I am adding the sample source file, test workflow, and screenshots.
