That worked. Thanks Phil. I was trying to accomplish before unpivot.

In my dataset I sometimes have rows, where all 12 of the 12 rows that I am unpivoting (using unpivot transform) contain a NULL. I wanted to filter those out before the unpivot.

However, if I use conditional split after the unpivot, on the aggregated column, it excludes those rows I'm after. So for now I am fine:-)

Still.....if I weren't unpivoting then I wouldn't have a solution. I wonder....how would I do the equivalent of this?

where

[Month 01] is null and

[Month 02] is null and

[Month 03] is null and

[Month 04] is null and

[Month 05] is null and

[Month 06] is null and

[Month 07] is null and

[Month 08] is null and

[Month 09] is null and

[Month 10] is null and

[Month 11] is null and

[Month 12] is null