Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

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

Highlighting row based on different fields and rows

lal
6 - Meteoroid

 

Hello,

 

I'm trying to highlight specific rows if value in "field 3" does not match with the rest of the columns that have the same values in "field 1" and "field 2". For example this is what my output looks like right now: 

field 1field 2field 3
aaa1
aaa1
aaa1
aaa1
aaa2
aba3
aba3
aba3
aba3
aba2
aba4
bab1
bab1
bab1
bab1
bab2.5

 

I want my output to have the rows with red to be highlighted:

field 1field 2field 3
aaa1
aaa1
aaa1
aaa1
aaa2
aba3
aba3
aba3
aba3
aba2
aba4
bab1
bab1
bab1
bab1
bab2.5

 

Basically I want to highlight the rows that are the odd ones out, dependent on field 3 IF field 1 and field 2 are the same.

 

Let me know if you have any ideas. 

 

Thanks in advance. 

2 REPLIES 2
JosephSerpis
17 - Castor
17 - Castor

Hi @lal I have mocked up a workflow that produces an output as you describe.

 

Highlight_Field.JPG

lal
6 - Meteoroid

Hey thank you for this!

 

If i created a new column "field 4" and wanted to auto-populated the row -that is now highlighted- with the value that it is ranked 1 for that field 1 +field 2 combo, how would I go about it? 

 

Thanks in advanced.

Labels