Reading the target data as look up

[deva]

Hi,
I have one requirement. While loading the data , based on the previous record we have to compare the current value. If its true I have to copy the previous column value in to current column.

How can I do this rek. I am using hash file to read the previous record.

please explain me.

[chulett]

That's how you would do it - use a hashed file to store and lookup the current value. What's not working for you? Are you building some kind of SCD?

[gateleys]

Hi,
I have one requirement. While loading the data , based on the previous record we have to compare the current value. If its true I have to copy the previous column value in to current column.

How can I do this rek. I am using hash file to read the previous record.

please explain me.

Define 'previous'.

If you mean previous row in a sorted data, then you could use the function RowProcGetPreviousValue().

[gateleys]

You could also use RowProcCompareWithPreviousValue() to perform the comparison.