Get Inspire insights from former attendees in our AMA discussion thread on Inspire Buzz. ACEs and other community members are on call all week to answer!

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