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

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Record count trigger Run if

Working on setting up record count match betweej source and target after ETL job compeletion.
tflowmeter catcher hold the record count, but I need to match this value to the record count from source data (for which I have used toracleinput with "select count"). when merging this count and record count from tflowmeter catcher, it takes null values (probably due to non matching field columns. has anyone coded something to do a etl record check at the end. I used with Talends Tjava & Tjavarow componets but get some "left had side assignement errrors".
I also notice that sometimes tflowmeter catcher does not read any records (0 records on data flow - am I doing something wrong?)
Assuming talend as a ETL tool should have record count check somewhere that I can use to trigger mails on pass or fail (with log)

Labels (2)
1 Reply
Anonymous
Not applicable
Author

After the flow has finished you can hit control+space in the white space and select the component followed by the NB_LINE. 
   
0683p000009MH7j.png
This will give you an output like this:  ((Integer)globalMap.get("tLogRow_1_NB_LINE"))

Which should give you the record row count for that flow.