Data select

[ImadM]

Hello !

I have 2 dataset which describe a list of people that they went to two different coffee A and B.

I would like to know all persons that they went at least one time to one coffee and not both. I tried unique tool but I think that I need a formula to select target data. 

Do you have any idea please?

Thank you

[cplewis90 · Accepted solution]

Hello @ImadM,

I am not sure if this is exactly what you are looking for. There is also a bit of a manual aspect to this in the select records tool. I probably could get to a more automated solution with a bit more thought.

[ImadM]

Hello cplewis90

I need to have just the persons that they went only to one coffee and no both. For example 

Please, see the dataset bellow

Thanks ! 

[cplewis90]

Hey @ImadM 

The solution I attached should work for this. In the first attachment the ages were different on those two people. It should work to remove any duplicates. 

Let me know if it does not and I will revisit the solution. 

[ImadM]

Great! Yes it works 

Thanks a lot 🙂