topic Re: To catch count of rows passed and rejected in Talend Studio

To catch count of rows passed and rejected

Anonymous — Wed, 13 Jun 2018 08:46:13 GMT

Hi All,

I just wanna know is there any way to catch the processed and rejected rows count,instead of using taggregaterow at each rejects. Bcz at the end I want to have a total number of records processed and rejected at each checks.

Thanks in Advance

Re: To catch count of rows passed and rejected

manodwhb — Wed, 13 Jun 2018 08:53:24 GMT

@Swathir,if you are populating rejects into .txt or .csv file you can get the global variable ((Integer)globalMap.get("tFileOutputDelimited_1_NB_LINE")) of tFileOutputDelimited .

Re: To catch count of rows passed and rejected

vapukov — Wed, 13 Jun 2018 08:54:50 GMT

You still need use some components for do the work

I use tJavaFlex and sequences (Numeric.sequence("sequence_name",1,1))

- just add to processed and rejected flows

Re: To catch count of rows passed and rejected

Anonymous — Wed, 13 Jun 2018 09:51:21 GMT

Hi manodwhb

I m using tSchemacompliance to have schema check and I need to calculate the number of processed and failed records.As you said, we cannot get NB_LINE from tSchemacompliance. I think tFlowmeter ll catch the record count but we cannot access the output count using global variables.