Highlight Rows with Null Patterns

[blitz45]

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!

Jan	Feb	Mar	April	May	June
1234	2665	[Null]	5645	[Null]	5557
6968	1544	4555	3588	6154	3544
3358	7789	8954	8866	[Null]	1145
[Null]	1124	[Null]	7445	1223	4429

Thank You,

[JosephSerpis · Accepted solution]

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 solution]

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

[blitz45]

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

[blitz45]

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