Unique Tool Help

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

Output

Custom Tools

Accepted answers

ShankerV

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

Unique Tool Help.yxmd

All comments

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

joaopmts

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

Thanks @ShankerV

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703