I would like to the get the record count of processed rows, but each record will be processed one at a time. So while I try to get the count of record to some context variable, I am getting the count as 1 always. Would like to know how to get the total count.
Here in the tfileOutputExcel_1, I am getting the detailed information and tfileOutputExcel_2, will have summary details (same excel will have two tabs one is summary and one is detailed).
I would like to get the total record count from detailed excel to summary excel
Solved! Go to Solution.
Find the attached mapping. Here I were creating excel file from csv file and then count the number of records in tJava ((Integer)globalMap.get("tFileOutputExcel_1_NB_LINE")).
You can find the list of variables in the "Outline" view on the bottom left of your screen.
Let me know if it helps.
My excel has to read one record at a time because of some job specifications and iterating the excel to read further records. So that makes the problem when I try to count the records.
Even after using this, I am still getting total count as 1 because it is reading one row at a time. Any other way to resolve this ?
Talend named a Leader.
Kickstart your first data integration and ETL projects.
Watch the recorded webinar!
Part 2 of a series on Context Variables
Learn how to do cool things with Context Variables
Find out how to migrate from one database to another using the Dynamic schema