Highlight Rows with Null Patterns
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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,
Solved! Go to Solution.
- Labels:
- Datasets
- Regex
- Tips and Tricks
- Workflow
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @blitz45 belive I have come up with a way of highlighting a row after a null value. Let me know what you think?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
I can definitely highlight the cells this way too, thank you so much!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
This is exactly what I wanted my output to look. Thank You!
