Alteryx Designer Desktop Discussions

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

Highlight cells in output

PB41091
7 - Meteor

I have a data set given as below. I have to compare values in column P with new P,  Q with new Q and R with new R.

PQRnew  Pnew Qnew R
210.1210.1
52-0.55-2-2
64406640
6-6-256+625
3+4103+410

 

And where there is change in values, I have to highlight those values. 

 

PQRnew  Pnew Qnew R
210.1210.1
52-0.55-2-2
64406640
6-6-256+625
3+4103+410

 

I have to get this output in excel as well as layout tool

2 REPLIES 2
DataNath
17 - Castor

Hey @PB41091, how does this look? For the 3 fields we just need to set up column rules to check whether p/q/r != new p/q/r and if this is true, colour the text red:

 

DataNath_0-1667384606515.png

 

Outcome gets you:

 

DataNath_1-1667384616895.png

 

To output to an Excel when using reporting tools, we just need to stick a Render tool on the end and choose Excel:

 

DataNath_2-1667384763972.pngDataNath_3-1667384774375.png

grazitti_sapna
17 - Castor

@PB41091 , You can easily achieve this using table tool and applying column rule by selecting columns and adding the condition as below:

 

grazitti_sapna_0-1667386792030.png

 

Sapna Gupta
Labels