Compare Two Lists of Same Structure and find the different records in second list

I am creating a functionality in my web application where I have two lists of same structure with 4 attributes. Each day a timer runs to filter the new data alone. The list structure has ID1, ID2, Value1, Value2 as attributes. The first list has the latest data and list2 is having the old data. Both list have same ID1 and ID2 whereas the Value1 and Value2 are different. Is there any way to filter the list records of List1 which are not same as of List2. We can ignore records with ID1 and ID2 having same Value1 and Value2 in both list1 and list2. I need to filter the records from List1 if Value1 or Value2 of ID1 and ID2 are different from List2 ID1 and ID2's - Value1 and Value2.

Example:

contents of List1:

101 22 D F

101 22 E F

102 44 D G

102 45 S E

103 47 S R

Contents of List2:

101 22 D F

101 22 E R

102 44 D G

102 45 S A

The result should contain:

101 22 E F

102 45 S E

103 47 S R

The result we should have should only be the latest data.


Did you have a look at the system action list distinct?

Sam Rijkers wrote:

Did you have a look at the system action list distinct?


The Application is already running on OutSystems 10 and List Distinct is not available on OS10. 

Further, I found out that, I need to do Left Join between the two lists and I need to filter the distinct records. Is there any way to do left join between list1 and list2?