topic Re: [resolved] Get the lookup inner join rejected row count in Talend Studio

[resolved] Get the lookup inner join rejected row count

Anonymous — Wed, 10 Dec 2014 02:37:31 GMT

Hi,
Is there a direct way to get the lookup inner join reject row count in Talend Open Studio for Data Integration?
Thanks and Regards,
Asanka.

Re: [resolved] Get the lookup inner join rejected row count

Anonymous — Wed, 10 Dec 2014 04:44:05 GMT

If you output the reject rows to a file or database, there is a global variable that counts the total number of rows are written on output component, for example:
...tMap..reject--tFileOutputDelimited
You can get the number of reject rows by using this global variable:

((Integer)globalMap.get("tFileOutputDelimited_1_NB_LINE"))

Shong

Re: [resolved] Get the lookup inner join rejected row count

Anonymous — Wed, 10 Dec 2014 05:28:48 GMT

Hi Shong,
Thanks for your reply.
In my case I'm writing the inner join rejected rows to an excel file (tFileOutputExcel). In my Talend Job there are several inner join rejects, but all are written to single excel file, but different sheets. So is there a way to get the number of rows written to a particular sheet?
Thanks and Regards,
Asanka.

Re: [resolved] Get the lookup inner join rejected row count

Anonymous — Thu, 11 Dec 2014 09:39:06 GMT

There is no global variable for sheet. You can define a counter on tJavaFlex to populate the total number of each rejected rows. For example:
...tMap..reject..tJavaFlex--tFileOutputExcel
in the beginning part of tJavaFlex, define a counter.

int counter=0;

in the main part:

counter++

in the end part, store the counter to a global variable or context variable for used later.

context.nb_reject1=counter;

Best regards
Shong

Re: [resolved] Get the lookup inner join rejected row count

Anonymous — Mon, 15 Dec 2014 02:05:04 GMT

Hi Shong,
Thank you very much for your reply. Your suggestion will work in my scenario.
Thanks and Regards,
Asanka.

Re: [resolved] Get the lookup inner join rejected row count

Anonymous — Mon, 15 Dec 2014 02:58:09 GMT

Great! Thanks for your feedback.
Best regards
Shong

Re: [resolved] Get the lookup inner join rejected row count

Anonymous — Sat, 08 Sep 2018 17:12:35 GMT

Hi,

I am getting null when I use this to print count