Remove duplicity on same time

Hi gmmb1,

You could achieve this by Query Editor like this (assume we have 2 columns Date and Id)

1. data with 2 columns
2. duplicated Date column
3. get date only 
4. duplicated Id column
5. Merge 2 new columns
6. remove duplicates by Merged Column

We have 2 columns in datasetduplicated Date columnI will select only Date and remove part of time cause you want check there are some orders in that date10 first charactersduplicated Id columnChoose 2 new duplicated columns (Id copy & date copy) to merge columndefault behaviorthe rest of things is choose Merged column and select Remove Duplicates

Note: If you want to check based on DateTime, you dont need to remove time part (just merge datetime and id, then remove dup on merged column)

If this works for you please accept it as solution and also like to give KUDOS.

Best regards
Tri Nguyen