PDI 7 and 8 (I did not check other version): Row denormaliser: Null if – does not work
I want to get null instead of zeros. Zeros ("0") are result of the aggregation (Number of Values) in Denormaliser step.
I don't think that's a bug, but more of a difference of intent on use.
Null If column is probably happening before the Aggregation -- that in turn will cause the aggregated values to be 0.
To make your flow logic clearer (think about when you've been promoted, and aren't maintaining this any more... you don't want your replacement to be bugging you all the time to explain what's going on!) follow your Denormalizer step with a "Null If" step.
Thank you very much. It sounds reasonable.
Retrieving data ...