Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik and ServiceNow Partner to Bring Trusted Enterprise Context into AI-Powered Workflows. Learn More!
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

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 Advance0683p000009MACn.png

Labels (2)
3 Replies
manodwhb
Champion II
Champion II

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

vapukov
Master II
Master II

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

Anonymous
Not applicable
Author

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.