Highlight Rows with Null Patterns

Question

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!

JanFebMarAprilMayJune12342665[Null]5645[Null]55576968154445553588615435443358778989548866[Null]1145[Null]1124[Null]744512234429

Thank You,

JosephSerpis · Accepted Answer

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

estherb47 · Accepted Answer

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.

Let me know if that works!

Cheers!

Esther