Alteryx Designer Desktop Discussions

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

Color a Duplicate values 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 Green color to a TRADE ID in column G which are appearing twice and give blue color to a TRADE IDs which are appearing more than twice in column G. I have attached file having 2 sheets named as INPUT (the dataset for colouring) and RESULT (I am looking for) as example. Your help is much appreciated

 

Thanks

Nikhil

2 REPLIES 2
Qiu
21 - Polaris
21 - Polaris

@HULK 
I think we can use the Formula option with PCXML to achieve this.

First we will do a count for TRADE ID and store in a new column "Count".

Use the "Count" to do a conditional formatting while unchecking it from output.

0419-HULK-1.PNG

0419-HULK.PNG

maushmisarkar
5 - Atom

Thank you for the solution @Qiu. This is very helpful.

Is there a way to extract the data in excel format instead of using the Browse tool? Or is there a way to extract the output in excel format from the browse tool?

Thanks.

Labels
Top Solution Authors