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.
Can you give some advice how to do this?
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
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!
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
Hi @aworker, I’m flattered!
Cool decision! thanks a lot
Thanks a lot @Karlygash for validating the solution !
And thanks to both @Karlygash and @takbb for your kind comments !
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.