Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Announcement | We'll be doing maintenance during the next 2-3 hours, which may impact your experience. Thanks for your patience as we work on improving the community!
SOLVED

Highlight Rows with Null Patterns

Meteor

Hi Everyone,

 

I was trying to figure out how I would write a formula that will highlight rows that has a value after a NULL (ie. Row 2: 2665, NULL, 5645)

For example, "If row has a value after NULL, highlight red." 

Any advice would greatly be appreciated!

 

JanFebMarAprilMayJune
12342665[Null]5645[Null]5557
696815444555358861543544
3358778989548866[Null]1145
[Null]1124[Null]744512234429

 

 

Thank You,

Highlighted
Alteryx Certified Partner
Alteryx Certified Partner

Hi @blitz45 belive I have come up with a way of highlighting a row after a null value. Let me know what you think?

 

Table_260819.PNG

Highlighted
Magnetar
Magnetar

Hi @blitz45 

 

Here is one approach. You'll need a field that identifies each row as unique (Row ID tool here), and then Transpose. A Multi-Row formula tool, grouping on the Row ID field, and looking to tag rows with null values but having a number below them with a Y. Others are tagged with an N.

 

A Summarize builds a tagging field that combines all of the Ys (and Ns) generated by the Multi Row tool, and that's joined back in.

Then you'll need a table tool to add the highlights (Alteryx doesn't really format your data unless you render it into a table). I used a Row rule, that adds a red fill to the row if the tagging field contains a Y.

 

image.png

 

Let me know if that works!

 

Cheers!

Esther

Highlighted
Meteor

I can definitely highlight the cells this way too, thank you so much! 

Highlighted
Meteor

This is exactly what I wanted my output to look. Thank You! 

Labels