DSXchange

Hello to all,

There are few records from source table like this

there is no status value for 2 other records.My req is if id and name matches then need to put staus 'y' in two ther records also.

I used stage variables to get the previous record value, but it worked if there are only 2 records with same ids,for the third record ,it is putting previous record value 'space' because 2nd record doesn't have any value.Can you please tell me how to do that

Thanks
Sri

Hi Sri,

it depends how you fill it.

IF FIELD="Y" THEN "Y" ELSE IF FIELD="N" THEN "N" ELSE FIELD

so you have y or n or a previous.

Thanks WoMaWil for your reply


Here it is logic

svCurrentValue =svPreviousValue
input.field =svCurrentValue

for the 2nd record it puts 'Y' ,because previous record has value 'Y' ,when it goes for 3rd record ,previous record from source table has space .So it is putting space in the 3rd record

I think here I need to hold the value of first record every time.Can you please give me some idea

Thanks