topic Re: Custom log messages from a tAggregateRow in Talend Studio

Custom log messages from a tAggregateRow

datajunkie1000 — Sat, 16 Nov 2024 00:02:29 GMT

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

Re: Custom log messages from a tAggregateRow

Anonymous — Fri, 18 Jun 2021 13:39:05 GMT

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";

Re: Custom log messages from a tAggregateRow

datajunkie1000 — Mon, 21 Jun 2021 10:03:09 GMT

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

Re: Custom log messages from a tAggregateRow

corentin1 — Mon, 21 Jun 2021 11:56:58 GMT

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)