DSXchange

Do you have version 8.5, which has looping in the Transformer stage?

Even so, you don't really need it. Use stage variables to compare the current row with the previous row and, where the key value is the same and the other value is missing, use the other value from the previous row.

Make sure that your data are properly partitioned and sorted (on the key value).

You need to change your logic slightly.

Use the below one.

sCurrentValue : If NullToValue(Input column,"")<> "" Then InputColumn Else sPreviousValue

sPreviousValue: InputColumn

Thank you Kondeti. It's working.

You may run in to trouble if your first ColB of a group is null, Stage Variables can't be null so you would need to default to an empty string.

There may be a bit of intelligence in DS to default for you but have my doubts.

I have other concerns but irrelevant if it's working...