Unique Tool Help

[joaopmts]

Hi Guys! How are you?

I need some help with the unique tool.

I have an example of my database, where billing account number is a ID for the customer, codigo_consulta is a id for a credit consult in the bank system and his score on that consult

My problem is, in my database i have some repeated id customers vinculated in repeated id consults and i must be only one billing account number and one codigo_consulta in the entire database and with de highest score possible.

But when I put a unique tool selecting either of any id, it will repeat or catch the lowest one. My target is to have an output like this.

Best regards

Joao

[ShankerV]

Hi @joaopmts 

The best possible way is to sort and then do the unique.

[joaopmts]

Hi! @ShankerV , but it's already sorted. I have sorted by biiling account number and then by codigo_consulta. When I do the unique by codigo_consulta I will end up with the second account number with the lowest score and when i do by billing account number, I get the same codigo_consulta for both account numbers

[ShankerV]

Hi @joaopmts 

Lets keep Colum A, B, C for better understanding and keeping it simple too.

Hope you are expecting only one unique value in Column B, with maximum value in column C.

Hope my understanding is right. Also one unique value per column A also.

Many thanks

Shanker V

[joaopmts]

Yes, you are right.

I forgot to metion, I have ordered by number of IDs of column B by IDs of colum A.

I think my example its not a perfect on since a unique selecting the colum A will work. But in some scenarios more IDs from column A is involved, I get repeated values on colum B.

So the perfect process its to get the first register from IDs from colum A and wipe the rest of them leaving the rest of IDs on column B free to be selected for other IDs from comlumn A.

Sorry for my bad english.

[ShankerV · Accepted solution]

Hi @joaopmts 

One way of doing this.

As requested, I have taken only column A and the max score from column C.

Then taken the column B where it will be unique.

Hope this helps...

Many thanks

Shanker V

[joaopmts]

For now it works, I will update this if any other problems comes up

Thanks @ShankerV