Portucale
Member
Hi,
I received a list every day which I need to compare with the existent list and extract records which are not in the existent list, like:
Existent List
10
11
13
15
16
New List
10
11
12
14
15
16
17
18
When I compare both lists I see that "New List" contains; 12;14;17 & 18 as not common with "Existent List" so, the final result would be:
Final List
10
11
13
15
16
12
14
17
18
In essence is just to add the records that New List contains, but aren't common in the Existent List.
Any help is appreciated,
Thanks,
I received a list every day which I need to compare with the existent list and extract records which are not in the existent list, like:
Existent List
10
11
13
15
16
New List
10
11
12
14
15
16
17
18
When I compare both lists I see that "New List" contains; 12;14;17 & 18 as not common with "Existent List" so, the final result would be:
Final List
10
11
13
15
16
12
14
17
18
In essence is just to add the records that New List contains, but aren't common in the Existent List.
Any help is appreciated,
Thanks,