Joining Queries - Cardinality- Unmatched

[JBCLARK20]

Hi All,

I have a variance report to run between 2 data snap shots.
I want to find those items that are in the Current snap shot and not in the Old snap shot.
Can this be done by setting the Cardinality in the Join Queries dialog box in Report studio?
If so how does one set the cardinality for an unmatched join?

Thank you.
 

[MFGF]

Hi,

I'd suggest an "EXCEPT" item from the toolbox might produce the desired outcome? It will return the rows in one query that don't exist in the other. Of course, the queries have to have the same number of items with the same data types for this to work - just as with a UNION.

Cheers!

MF.