4 Replies Latest reply: Dec 1, 2017 11:52 AM by daniel melo

# Outer Join in set analysis

Hello all,

How Can I count the number of persons given the following in set analysis?

I was trying this, but it didn't give the results that I need

count( {<Placement-={''}>+<Successor-={''}> }distinct [Person ID])

• ###### Re: Outer Join in set analysis

Use the '/' XOR set operator (either A or B, but not both)

Count({<Placement = {''}>/<Successor = {''}>} Distinct [Person ID])

• ###### Re: Outer Join in set analysis

Or better,(unless you are explicitly filtering for blanks strings):

Count({<Placement = P(Placement)>/<Successor = P(Successor)>} Distinct [Person ID])

• ###### Re: Outer Join in set analysis

Seems okay to me, What is the wrong and what are you trying here?

count( {<Placement-={'*'}-{''}>+<Successor-={'*'}-{''}>} distinct [Person ID])

OR

count( {<Placement-={"=Null()"}>/<Successor-={"=Null()"}>} distinct [Person ID])

• ###### Re: Outer Join in set analysis

This one worked to me!

Count({<Placement = {''}>/<Successor = {''}>} Distinct [Person ID])