Pentaho Tips

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.