DSXchange

In parallel jobs the Remove Duplicates stage has a First or Last option, and does not "break parallelism". ... True, but as mentioned above, it accepts/rejects an entire record and does not examine each column to give a LAST NON-NULL value per column. I wish it did - would make life easie...

QualityStage might not be an option, but I'll look into it for sure. It looks like I'm stuck with the good ol' Transformer and stage variables as suspected. The Sort / Group Change trick should save some transformer logic. The Server version of Aggregator has a First and Last operator - not sure how...

Hi All. I am trying to determine the best method for obtaining the last non-null value for each column within a key (or group of keys). Could not find anything by searching the forum. Here's a data scenario: <pre> ROW# C1 (KEY) C2 C3 C4 ---- -------- ------ ------ ------ 1 1000 ACME <NULL> 999 2 100...