Filter same ID for different client names

Question

Hello,

In my dataset I have the following table.

IDClient name123Client A

456Client B789Client C0147Client A456Client C

I need two soluction here: make sure each client has its own ID and that each ID has refers to only one client. I would like to filter, in case there are any clients with two different ID.

In this case, I would have to filter the last 2 lines, because these don't follow my requirements.

Thank you in advance.

Christine_Assaad · Answer

Hi @beatrizmguerreiro

Is this what you are looking for?

Filter IDs based on Client name.yxmd

beatrizmguerreiro · Answer

Hello Ladarthur,

In the case above, I explained that I need both checks:

* check if I had multiple ID for a client

* check if I had multiple client names for one id.

In your solution, the join tool is indicating as unique value one client with different VAT IDs.

Can you help me here?

Ladarthure · Answer

Hi @beatrizmguerreiro,

to do so, you can use a summarize and group by ID, count distinct by client name and then filter on the ID where you have more than 1 client name. You can then use this with a join for your dataset.

doubles.yxmd