Transform Steps:
if ( PRIMRATECCY == "TWD" || PRIMRATECCY == "KRW" || PRIMRATECCY == "IDR" || PRIMRATECCY == "JPY" ) {
//round up to zero decimal
RebateRounded = str2num(REB).toFixed(0);
} else {
//round up to 2 dec
RebateRounded = str2num(REB).toFixed(2);
}
Do not add generated file to result.
Tag generated file to a category, e.g. Warning
In the job, send email with attachment, and add the category to the attachment.
Note, this does not work with .txt files, due to an unknown bug Pentaho + Linux. It works well with .xls attachment.