Splitting tables according to rules
Hello everyone,
I’m trying to split a table, which contains driving data of a race track, but I cannot reach my goal yet. The table contains 4 columns: timestamp, latitude, longitude, velocity. And then, there are multiple thousands of rows for each timestamp.
From lat and long I already was able to set up the finish line of the track.
For instance, I know that the data contains 4 rounds. These 4 rounds shall be splitted into separate tables, one table per round.
With rule-based row filter node I filtered out exactly the 4 rows where the driver passes the finish line. Basically, the result of the filter is a simple table with those aforementioned 4 columns and now only 4 rows.
But now I dont know how to use this information to split the original table into 4 separate tables.
I’ve tried everything I’ve found here in the forums like Row Splitter, Table Splitter, Reference Row Splitter and so on, but I seem to be to stupid to make proper use of them.
Do you have an idea? Any help is highly appreciated :slight_smile:
I’ve just started to work with knime and downloaded it today (v5.2.3) , so please be kind if the question is too stupid.
Thanks,
Tim