Five Stars

To catch count of rows passed and rejected

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 AdvanceSmiley Happy

3 REPLIES
Twelve Stars

Re: To catch count of rows passed and rejected

@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 .

Manohar B
Twelve Stars

Re: To catch count of rows passed and rejected

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

-----------
Five Stars

Re: To catch count of rows passed and rejected

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.