Icon

20210622 Pikairos Moving row down by the condition

There has been no description set for this workflow's metadata.

The Java snippet code:// Your custom variables:String previousTransaction = "";// Enter your code here:if ( previousTransaction.equals( "Bonus Applied" )){ out_Result = previousTransaction; } else if ( c_TransactionOutExceptions.equals( "Bonus Applied" )){ out_Result = ""; } else{ out_Result =c_TransactionOutExceptions; }previousTransaction = c_TransactionOutExceptions; Sort by DateThe dataThe simplestway to solve this:Set stringmissing valuesto blankAn alternativeKNIME purist way ;-)Apply the following rules:$Transaction Out Exceptions$ = "Bonus Applied" =>"" $Transaction Out Exceptions(-1)$ = "Bonus Applied" => $Transaction Out Exceptions(-1)$TRUE => $Transaction Out Exceptions$Filter out useless columnsSorter Excel Reader (XLS) Java Snippet Missing Value Lag Column Rule Engine Column Filter The Java snippet code:// Your custom variables:String previousTransaction = "";// Enter your code here:if ( previousTransaction.equals( "Bonus Applied" )){ out_Result = previousTransaction; } else if ( c_TransactionOutExceptions.equals( "Bonus Applied" )){ out_Result = ""; } else{ out_Result =c_TransactionOutExceptions; }previousTransaction = c_TransactionOutExceptions; Sort by DateThe dataThe simplestway to solve this:Set stringmissing valuesto blankAn alternativeKNIME purist way ;-)Apply the following rules:$Transaction Out Exceptions$ = "Bonus Applied" =>"" $Transaction Out Exceptions(-1)$ = "Bonus Applied" => $Transaction Out Exceptions(-1)$TRUE => $Transaction Out Exceptions$Filter out useless columnsSorter Excel Reader (XLS) Java Snippet Missing Value Lag Column Rule Engine Column Filter

Nodes

Extensions

Links

Download

To use this workflow in KNIME, download it from the below URL and open it in KNIME:

Download Workflow
Created by: Molina
Created at: 2021-06-22
On NodePit since: 2022-02-06
Last update: 2024-11-21
Created with KNIME version: v4.2.4

Deploy, schedule, execute, and monitor your KNIME workflows locally, in the cloud or on-premises – with our brand new NodePit Runner.

Try NodePit Runner!