Create Rows

[renantex]

hello people,
I need to create new row in the database based on other rows.
If the value of column Y in the row is differente from the value in the same column of the next row, I need to create a new row with specific values.

[Mark_Ortmann]

Hey @renantex,

welcome to the community!

Could you give us a toy example of what your input and expected output would look like (no real data required )?

Maybe one of these posts is a good starting point?

Finding values where the previous row's value was less than or equal.

Hello, I’ve been trying to create a workflow that will highlight any rows that have a value that is less then or equal to the previous row’s value. I thought of using the Lag Column to add the previous rows value and then use the row filter to remove any that are greater than the previous value, but I don’t think there is a way to do that with the row filter. Am I going about this the right way? Thanks, Kevin

Filter row Which occur just above the specified number of value

I want to select the rows which comes above the value 95 in the column eg col1 1 2 70 95 30 40 95.7 40 78 96 i want to have the rows of col1 70 40 78

[renantex]

Thanks @Mark_Ortmann,
I need the following:
if the value of column “out” is different from the “in” column of the next line, insert a new row with the values I need.
see if the pictures help

[HansS]

Hi @renantex

I guess this workflow solves your problem create rows.knwf (39.2 KB)
gr. Hans

[renantex]

Beautiful @HansS!

Problem solved.