DSXchange

Welcome aboard. This is most easily accomplished, once data have been sorted by the key, in a Transformer stage using stage variables to detect whether a non-null value has already been processed for the current key. As many rows are output as are input, into a Remove Duplicates stage that allows o...

For Every unique key column value, i need to get the 1st NotNull values of every column based upon the source priority. SOURCE File: Key Source Col1 Col2 2000 A NULL DEF 2000 B NULL NULL 2000 C XYZ NULL 2001 A PQR NULL 2001 C NULL RXB 2001 D OIO ABC 2002 A NULL NULL 2002 B IOP NULL 2002 C NULL NULL ...