topic Re: How to get data only every 10 seconds instead of every second? in App Development

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

Polido — Fri, 01 Oct 2021 12:04:50 GMT

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!

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

Digvijay_Singh — Fri, 01 Oct 2021 13:58:16 GMT

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;

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

Polido — Wed, 06 Oct 2021 12:22:17 GMT

Thank you very much! I believe this will work 🙂

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

Cheers