De-flatten Rows with matching Source

[JavaGirl]

Below is a sample of the input data I am working with. 

Ind	MID	RptYear	StartDate	Source	Result	Output
123	10023547	2022	2/4/2022	A
1234	10023547	2022	1/8/2022	B	7	Keep
8816946	10103825	2022	2/4/2022	A	>7	Keep
87865152	829700098	2022	2/9/2022	B	6.5	Keep
54357461	1010398372	2022	1/19/2022	A
54357461	1010398372	2022	1/19/2022	B	6.9	Keep

Notice the Column labeled output is not part of the input data, but a notation of the desired output.  I need to generate an alteryx workflow that will do the following: 

1.  When there are two rows of data with the same MID and different Sources, retain or keep only the row with lab results that are not null or empty. 

2.  When when the row dos not have both sources, retain the record by default. 

How is this accomplished in Alteryx?  

Does anyone have any examples they can provide?  

Thank you in advance. 

JavaGirl!

[PhilipMannering · Accepted solution]

Hi @JavaGirl 

Maybe something like this,

[JavaGirl]

Hey Philip!  This is beautiful!  Love how clean and to the point it is.  

Thank you for your help!