Color Duplicate fields in a particular column

[HULK]

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

[atcodedog05 · Accepted solution]

Hi @HULK 

You can achieve this using reporting tool like the below.

Hope this helps : )

[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 · Accepted solution]

Hi @HULK 

Here is the updated workflow

Hope this helps : )

[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 · Accepted solution]

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

Hope this helps : )

[atcodedog05]

Happy to help : ) @HULK 

Cheers and have a nice day!