Custom log messages from a tAggregateRow

[datajunkie1000]

Hi All

I have a tAggregateRow component which outputs the rowcount of a specific column. How can I log a custom message stating "[x] rows processed"?

Here is the subjob with the tAggregateRow

and here is the detail of the tAggregateRow

Thanks

[Anonymous]

After tAggreGateRow, you can add a tJavaRow and output the messages like:

tAggreGateRow--main--tJavaRow

on tJavaRow:

System.out.println("["+input_row.acd+"]" rows processed";

[datajunkie1000]

Hi

Getting an error "input_row cannot be resolved to a variable" - how do I proceed with this?

[corentin1]

global variable "tDBOutput_1_NB_LINE" could also be used in your case I think (it will show the number of lines processed by the tDBOutput component). You can use it in a tJava linked with onSubjobOK from your current subjob.

Then simply yse System.out.println(((Integer)globalMap.get("tDBOutput_1_NB_LINE)));

(see "outline" tab in studio for exact syntax)