Color Duplicate fields in a particular column

Hello,

Is there a straight forward way to color duplicate value in a column. All I want to do is give yellow color to a TRADE ID in column A which are appearing twice and give blue color to a TRADE ID in column A which are appearing more than twice in column A. Your help is much appreciated

Thank

Duplicates.xlsx

Common Use Cases

Accepted answers

atcodedog05

Hi @HULK

You can achieve this using reporting tool like the below.

Hope this helps : )

Duplicate.yxmd

atcodedog05

Hi @HULK

Here is the updated workflow

Hope this helps : )

Duplicate (1).yxmd

atcodedog05

Hi @HULK

Here is the config

Learn more about reporting tools here https://community.alteryx.com/t5/Interactive-Lessons/tkb-p/interactive-lessons/label-name/Reporting%20in%20Designer

Hope this helps : )

All comments

atcodedog05

Hi @HULK

You can achieve this using reporting tool like the below.

Hope this helps : )

Duplicate.yxmd

atcodedog05

Happy to help : ) @HULK

Cheers and have a nice day!

HULK

Many thanks sir - actually In my output I also need original fields colored. e.g. TRADE ID 124 (second row) is not colored. Also I need different color for fields which are appearing twice and another color for fields which are appearing more than twice. please help. Congratulations @ atcodedog05

atcodedog05

Hi @HULK

Here is the updated workflow

Hope this helps : )

Duplicate (1).yxmd

HULK

Congratulations @ atcodedog05 - can you also share the settings you used in Basic table to highlight yellow color. When I download the workflow you have attached I dont see any thing on BASIC table part, apologies for any trouble

atcodedog05

Hi @HULK

Here is the config

Learn more about reporting tools here https://community.alteryx.com/t5/Interactive-Lessons/tkb-p/interactive-lessons/label-name/Reporting%20in%20Designer

Hope this helps : )

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703