Keep only one line per distinct case

PolBe — Wed, 20 Mar 2019 16:00:05 GMT

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

Re: Keep only one line per distinct case

anushree1 — Thu, 21 Mar 2019 06:14:29 GMT

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

PolBe — Thu, 21 Mar 2019 08:02:38 GMT

do you see the printscreens in my text?