Moving row down by the condition

[Karlygash]

Hello, dear users!

I am struggling with moving down rows by specific condition.

I have such data, and in the column TransactionsOut the value Bonus Applied should be moved into next row. But value Missed Out Punch should not be moved to the next row
How it should look like.

test.knwf (7.5 KB)

Can you give some advice how to do this?

[aworker]

Hi @Karlygash

Interesting problem. I’m afraid, I have the impression that the workflow you upload is reset and hence without data. Could you please upload it making sure first that is run and the Reset box is not checked when you export it?

Thanks and looking forward to helping

Best

Ael

[Karlygash]

oh, sorry
I have unchecked the reset check box test.knwf (19.1 KB) check.xlsx (10.0 KB)

Actually I have only input file in the workflow and sorter

I really appreciate your help!

[aworker]

Hi @Karlygash

Thanks for the data and no problem at all !

Please find two possible solutions:

• The first one is based on a single Java snippet node (which follows the hints by @takbb here).
• The second one is purely based on KNIME nodes.

20210622 Pikairos Moving row down by the condition.knwf (64.7 KB)

Hope this helps

Best

Ael

[takbb]

Hi @aworker, I’m flattered!

[Karlygash]

Cool decision! thanks a lot

[aworker]

Thanks a lot @Karlygash for validating the solution !

And thanks to both @Karlygash and @takbb for your kind comments !

Best wishes

Ael