Hi fellow knime users,
I have a problem that I just can’t wrap my head around.
Given the following Time Series Data:
Location Date Usage
H1 01.01.2021 0
H1 02.01.2021 0
H1 03.01.2021 0
H1 04.01.2021 1
H1 05.01.2021 2
H2 01.01.2021 0
H2 02.01.2021 0
H2 03.01.2021 1
H2 04.01.2021 0
H2 05.01.2021 2
There are different Locations, all with the same start and end date, but some start with 0 and I want to find the first (not all, just the first) non zero value per location and want to remove the leading zero rows.
So the transformed data would look like this:
Location Date Usage
H1 04.01.2021 1
H1 05.01.2021 2
H2 03.01.2021 1
H2 04.01.2021 0
H2 05.01.2021 2
Extra points for a solution where I can define the window of how many leading values should be removed.
The only solution I can think of is a dopple loop, but that not a very elegant solution.
Thanks very much in advanced