Color Duplicate fields in a particular column
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
Solved! Go to Solution.
- Labels:
- Common Use Cases
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Happy to help : ) @HULK
Cheers and have a nice day!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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 : )
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Happy to help : ) @HULK
Cheers and have a nice day!
