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.
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.
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?