Condtions in transformer/Any other options
Posted: Mon Aug 17, 2015 9:53 am
All,
Need a help with a condition in DS parallel job.
I have a DB2 table, there are three columns as below. Key is ID.
ID, Start_Dt, End_Dt, Status
1,10/22/2012,11/10/2015,In Process
1,10/22/2012,11/10/2016,In Process
We need to update the the row to "Completed" if it finds same record with future END_DT. When we pull the data for reports, we pull In Process one. So, now its incorrectly getting 2 records. but as process is renewed for this ID , we need to make the old one as Completed.
Appreciate your help.
Thanks.
Need a help with a condition in DS parallel job.
I have a DB2 table, there are three columns as below. Key is ID.
ID, Start_Dt, End_Dt, Status
1,10/22/2012,11/10/2015,In Process
1,10/22/2012,11/10/2016,In Process
We need to update the the row to "Completed" if it finds same record with future END_DT. When we pull the data for reports, we pull In Process one. So, now its incorrectly getting 2 records. but as process is renewed for this ID , we need to make the old one as Completed.
Appreciate your help.
Thanks.