Values before and after a value

Hi,

I know the description sounds a little bit wired. But I am trying to explain it more detailed :slight_smile:

I want to read only the marked data:

loiter mode

data

data…

auto mode

data

data…

Loiter mode

data

data…

Auto Mode

data

data

data

data…

Loiter mode

data

data…

these data are from a drone log file. I want to use these data for a trainings data set (decision tree)

the first Loiter is the starting point. The first auto are the data to the first waypoint. The Second Loiter is the point from which I would like to have the data. Second auto is the auto-mission. Third loiter is the end from the mission. Rest of the data is landing.

Does anyone has an idea - how to do that?

thanks!

Hello @buechertasche123,

You might use the Column Lag node


for that purpose…

Hi @buechertasche123

See this workflow before after value.knwf (47.5 KB) it divides your dataset in batches based on loiter and auto. You only need to append a row filter. Hope this helps.
gr. Hans

2 Likes

Dear Hans,

sorry for the late response!
The KNIME Community is awesome. Thank you so much for the effort you put into my project.

May i ask you one more question?
I was able to use your workflow in my case. Then i performed a group by node for the data i needed and i tried to used these group by values for a decision tree. Problem is… Decision Trees can not handle group by nodes. Do you see any chance to work with groups - by using decision trees? Is my question understandable or do you need the workflow?

kind regards

2 Likes

Hi @buechertasche123

Of course you can ask as many questions as you like :upside_down_face:
Without knowing your workflow I would suggest to have you decision tree and other relevant nodes between a Group Loop Start en Group Loop End node.
gr. Hans

2 Likes

Dear Hans,

attached is my workflow. This workflow works pretty well when the drone is not moving or is pointing forward for instance. But what i want is the whole manoeuvre. So the decision tree is suppose to handle Datasets and not only one row. Do you think that is possible?

thank you very much!

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