Hi All,
We have multiple rows and based on row data compare need to change few rows data and few rows need to remove.
In the Attached workflow we have added Input and Required output format, please check and let us know if we are able to achieve same.
@bhaushedbale
You have to elborate more about the logic here.
@bhaushedbale
I have to assume this has something to do the date sequence.
Hi,
Thanks for the reply, I was not well and unable to reply. Need a small change in workflow.
Input is as mentioned here
ID | EID | E_Name | Role | TE_ID | TE_Name | GE_ID | GE_Name | effective_date | termination_date |
528 | 29019085 | ABC | LA | 29025173 | XYZ | 28000457 | LPPT | 9/22/2017 | 2/8/2019 |
528 | 29019085 | ABC | LA | 29000866 | PQS | 28000457 | LPPT | 2/8/2019 | 3/1/2019 |
528 | 29007959 | DEF | LA | 29000866 | PQS | 28000457 | LPPT | 3/1/2019 | 3/4/2019 |
528 | 29007959 | ABC | LA | 29000866 | PQS | 28000457 | LPPT | 3/4/2019 | 6/28/2019 |
528 | 29007959 | DEF | LA | 29000866 | PQS | 29025491 | ALM | 6/28/2019 | 7/28/2019 |
528 | 29007959 | DEF | LA | 29000866 | PQS | 29025491 | ALM | 7/28/2019 | 12/31/9999 |
The output should be as below.
ID | EID | E_Name | Role | TE_ID | TE_Name | GE_ID | GE_Name | effective_date | termination_date |
528 | 29019085 | ABC | LA | 29025173 | XYZ | 28000457 | LPPT | 9/22/2017 | 3/1/2019 |
528 | 29007959 | DEF | LA | 29000866 | PQS | 28000457 | LPPT | 3/1/2019 | 3/4/2019 |
528 | 29007959 | ABC | LA | 29000866 | PQS | 28000457 | LPPT | 3/4/2019 | 6/28/2019 |
528 | 29007959 | DEF | LA | 29000866 | PQS | 29025491 | ALM | 6/28/2019 | 12/31/9999 |
@bhaushedbale
Sorry. I have to give up even I have spent much time on it.
Only with the input and output, I cannot figure out the logic here.