Keep only one line per distinct case

[PolBe]

hi,

I am struggling for a while with the following:

I have two tables: Incoming Requests and Closed Requests

The only Field containing unique value is Request number. All other Fields can have their values changed during the Request life time. 

Some extra info: Not all the Incoming requests are closed.

Closed table can have Fields which are not present in Incoming and the other way around.

Conditions:

 For each Request I want to get in the end only one line in the final table where I see:

1. Request number

2. Request entering Date + Time - the very first one 

3. Group sent to - the very first one 

4. all the other fields need to be displayed with the latest value (see example 'Cause' column) .

So the logic will be first to display Requests from the Closed table and show the latest values from table Closed + Fields from Table Incoming.

then add those Requests which are left (not having closed date) in the Incoming table with above conditions. 

I hope someone can help me.

Greetings,

Polina

[anushree1]

A sample data and desired output details could help to understand and work on the desired solution 

[PolBe]

do you see the printscreens in my text?