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

NB_LINE and tFlowmeterCatcher

Does anyone know if it is possible to manually (and elegantly) send row counts to tFlowMeterCatcher? 

I am working with the ELT components for Oracle and I dont see any possibilities to collect row count information other than by using the global variables NB_LINE. Is it possible to send NB_LINE directly to tFlowMeterCatcher or eventually via tFlowMeter or how would you do it?

Maybe somehow it is possible to raise the event that triggers  tFlowMeterCatcher ?

Kind regards, Lise
Labels (2)
10 Replies
Anonymous
Not applicable
Author

Hi Lise
As kzone suggested, try this 
...tELTOracleMap....
      |
onsubjobok
      |
tFixedFlowInput--main--tFlowMeter--tLogRow
tFlowMeterCatcher--main--insert into DB or File.
on tFixedFlowInput, get the value of  NB_LINE variable and output it so that it can be monitored by tFlowMeter component. Define one column with Integer/int type, and set its value as:
((Integer)globalMap.get("tELTOracleOutput_1_NB_LINE"))

Best regards
Shong