Remove Duplicates

[Anonymous]

Dear All,

I Want to remove Duplicates Values from somes Calls in my Application. Here ist the Description:

Please make the check of the duplicates for 24 hours (from 00:00 till 23:59).

Description:

1. Duplicates must be removed only for Automatic and Manual (not for Info)
2. Automatic is counted as not a duplicate in case an Info Call happened before
3. Automatic is acknowledged as Duplicate if:
   - there is less than one hour to the previous Automatic for the same VIN
   - there is no info call between the automatic and the previous automatic for the same VIN
4. Manual is acknowledged as Duplicate if:
   - there is less than one hour to the previous Manual for the same VIN

Here are some examples

Info Mo 00:40	Automatic Mo 00:41	Automatic Mo 00:45	Info Mo 01:05	Automatic Mo 01:10
1	1	0	1	1
Total:
	Info	2
	Automat	2

Info Sa 23:50	Automatic Sa 23:52	Automatic Mo 00:05
1	1	1
Total:
	Info:	1
	Automat:	2

Info Mo 00:40	Automatic Mo 00:41	Automatic Mo 01:42
1	1	1
Total:
	Info:	1
	Automat:	2

Manual Mo 00:40	Manual Mo 00:41	Manual Mo 01:42
1	0	1
Total:
	Manual:	2

Can someone help me please?

Regards,

William

[MarcoWedel]

speaking of removing duplicates, please refrain from posting the same question multiple times:

Remove Duplicates

Remove Duplicates

thanks

regards

Marco