Suppose we are having a sales file with columns amount, amount_paid_date and last_paid_date. We have to update the last_paid_date column with the previous value of amount_paid_date when the amount is zero, else the same corresponding date of amount_paid_date should be displayed in the last_paid_date.
Hi
Link the file input component to a tJavaRow, put the Last_paid_date to global variable if the amount is Not zero. On a tMap, get the Last_paid_date from the global variable if the amount is zero. eg:
tFileInputxxxx--tJavaRow--main(row2)--tMap-->
on tJavaRow:
output_row.Id = input_row.Id;
output_row.Amount = input_row.Amount;
output_row.Amount_paid_at = input_row.Amount_paid_at;
output_row.Last_paid_date = input_row.Last_paid_date;
if(input_row.Amount!=0){
globalMap.put("key",input_row.Last_paid_date);
}
In the expression of Last_paid_date column on tMap,
row2.Amount==0?(String)globalMap.get("key"):row2.Last_paid_date
// Assuming the Last_paid_date is read with string type.
