How to get data only every 10 seconds instead of every second?

[Polido]

Hello everyone!

I've tried to search if this was already solved on the forum but I only found topics about the refresh / load tasks.

I'm using a QVD that has data for every second, but I only want to populate a table / world map with data from every 10 seconds interval.

Is this possible? And how it should be done in the data load editor?

Thanks in advance!

[Digvijay_Singh · Accepted solution]

Something like this may be - 

source:
Load * inline [
Datetime
2020-11-05 08:37:50
2020-11-05 08:37:51
2020-11-05 08:37:52
2020-11-05 08:37:53
2020-11-05 08:37:54
2020-11-05 08:37:55
2020-11-05 08:37:56
2020-11-05 08:37:57
2020-11-05 08:37:58
2020-11-05 08:37:59
2020-11-05 08:38:00
2020-11-05 08:38:01
2020-11-05 08:38:02
2020-11-05 08:38:03
2020-11-05 08:38:04
2020-11-05 08:38:05
2020-11-05 08:38:06
2020-11-05 08:38:07
2020-11-05 08:38:08
2020-11-05 08:38:09
2020-11-05 08:38:10
];

NoConcatenate
Final:
Load Datetime
resident source
Where Mod(Second(Datetime),10)=0
;

Drop table source;

[Polido]

Thank you very much! I believe this will work 🙂

I still need to do more testing but the data looks good, thank you!

Cheers