Compare multiple rows based on Group by fields and remove few rows and updated few rows

[bhaushedbale]

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.

[Qiu]

@bhaushedbale 
You have to elborate more about the logic here.

[Qiu]

@bhaushedbale 
I have to assume this has something to do the date sequence.

[bhaushedbale]

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

[Qiu]

@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.

[JesseMoyer]

Took a shot at it and attempted to guess the logic that was used to generate the output.  Assumed that unique groupings based on EID,E_Name, and GE_ID needed the earliest effective date and latest termination date.