Remove Duplicates

Anonymous — Thu, 01 Nov 2018 08:05:54 GMT

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:

Duplicates must be removed only for Automatic and Manual (not for Info)
Automatic is counted as not a duplicate in case an Info Call happened before
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
Manual is acknowledged as Duplicate if:
- there is less than one hour to the previous Manual for the same VIN

Here are some examples

Can someone help me please?

Regards,

William

Re: Remove Duplicates

MarcoWedel — Sun, 04 Nov 2018 21:12:27 GMT

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

thanks

regards

Marco