Row Values Repetition

ray.wurlod · Post by **ray.wurlod** » Mon Feb 27, 2012 7:11 pm

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).

kondeti · Post by **kondeti** » Mon Feb 27, 2012 7:39 pm

You need to change your logic slightly.

Use the below one.

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

sPreviousValue: InputColumn

bicap · Post by **bicap** » Mon Feb 27, 2012 8:13 pm

Thank you Kondeti. It's working.

Kryt0n · Post by **Kryt0n** » Mon Feb 27, 2012 11:56 pm

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...