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.

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