In case you missed the announcement: Alteryx One is here, and so is the Spring Release! Learn more about these new and exciting releases here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Color Duplicate fields in a particular column

HULK
7 - Meteor

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

7 REPLIES 7
atcodedog05
22 - Nova
22 - Nova

Hi @HULK 

 

You can achieve this using reporting tool like the below.

 

atcodedog05_0-1645529562012.png

 

Hope this helps : )

 

atcodedog05
22 - Nova
22 - Nova

Happy to help : ) @HULK 

Cheers and have a nice day!

HULK
7 - Meteor

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
22 - Nova
22 - Nova

Hi @HULK 

 

Here is the updated workflow

 

atcodedog05_0-1645611027180.png

 

Hope this helps : )

 

HULK
7 - Meteor

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
22 - Nova
22 - Nova

Hi @HULK 

 

Here is the config

 

atcodedog05_0-1645634317229.png

 

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

 

Hope this helps : )

 

atcodedog05
22 - Nova
22 - Nova

Happy to help : ) @HULK 

Cheers and have a nice day!

Labels
Top Solution Authors