Time series - How to eliminate data included inside multiple time windows

Hello everybody,

I’m dealing with a time-series type dataset. I’d like to eliminate data samples included between two dates (let’s say to eliminate all of the data associated with a timestamp inlcluded between 2010-01-01 and 2010-03-01). And I have to eliminate multiple time windows inside the dataset.
To do so I was trying to use “Extract time window (legacy)” node but it just allows me to include these samples and not to eliminate them.
Does anybody have a solution to my problem?
Maybe I’m just messing around :slight_smile:

Thank you very much,
have a great day!

Hi @zogo,

you can take a Reference Row Filter to eliminate the records Extract time window (legacy) from your hole dataset.

Bildschirmfoto%20von%202019-06-25%2020-21-34

Bildschirmfoto%20von%202019-06-25%2020-21-44

If there are more time windows to eliminate then ‘Concatenate (Optional in)’ these records before using the Reference Row Filter.

I hope it helps
Andrew

3 Likes

Thank you very much Andrew!

I will try it as soon as I can

Have a great day!

Andrea

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.