I am tryng to create an exception report that matches Purchase orders & products between two sources
The first table has the felds:
[Purchase Order Number]
[Product]
[Quantity Received]
[Delivery Date]
The second table has:
[Purchase Order Number]
[Product]
[Quantity Sent]
[Request Date]
I have created a link field called %POProductKey which is the concatenation of [Purchase Order Number] and [Product]. I am not loading [Purchase Order Number] or [Product] from the first table to avoid synthetic keys.
The issue I have is if there is a %POProductKey in the first table that isn't in the second table it doesn't show the data for either in my exception report so both are 0 and it looks like there are no differences
Do I need to link the tables in a different way?
Thanks