remove

[antonybi]

Hi,

I have been trying remove the duplicate login times(6:30 and 15:30)

How do we remove these duplicates??

urgent,kindly suggest.

PFA, for your reference!!!

[Anil_Babu_Samineni]

May be this?

Aggr([login time], [login time])

[sunny_talwar · Accepted solution]

Load your data like this

temp:

LOAD Time(Round([login time], 1/1440)) as [login time]

FROM

demo.xlsx

(ooxml, embedded labels, table is Sheet1);

[antonybi]

Thank you sunny !!!

I wanted to know whats wrong with the existing format????

[sunny_talwar]

Not entirely sure, but it seems that this was related to decimal numbers not entirely matching between the two 6:30 pm... they might look something like this

0.27083333333333333

0.27083333333333334

In order to make the two number equal, we rounded them to the nearest minute... you can round them to nearest second, if you have seconds by using this

temp:

LOAD Time(Round([login time], 1/86400)) as [login time]

FROM

demo.xlsx

(ooxml, embedded labels, table is Sheet1);