Howto read a next row value of coumn 1 ,if previous row value of column3 is 'delegated'

[Naresh]

Hi Guys,

Pls answer the below query.

I have three columns in a collection lets say column1,column2,column3. i want to read value based on condition i.e. if (collection.column3 )value is 'delegated', I need to copy the value of next row value of column1.

Thanx in advance

 

[Sukesh Kumaru]

Hi Naresh,
First of Loop the Collection (where your 3 columns are present)

take a calc stage and write an expression of Collection.column3="delegated" store the result in flag data type i.e True of False,

if found true, immediately in next iteration check the condition that flag data item has value "True"
then use calc stage and copy Collection.Column1 value as per requirement.

NB: check the condition is true or false at the begining of every loop iteration.

 

[Naresh]

Could u share decision and calc3 stages as well.

Thanx in advance

 

[Sukesh Kumaru]

Hi,
PFA of calc3 stage.