Filter same ID for different client names

[beatrizmguerreiro]

Hello,

In my dataset I have the following table. 

ID	Client name
123	Client A
456	Client B
789	Client C
0147	Client A
456	Client 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.

[Ladarthure]

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.

[beatrizmguerreiro]

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? 

[christine_assaad]

Hi @beatrizmguerreiro 

Is this what you are looking for?