Need to get the record count

Five Stars

Need to get the record count

Hi ,

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 excelCapture2.PNG

 

 

 


Accepted Solutions
Five Stars

Re: Need to get the record count

Issue has been resolved after i used sequence in the column

All Replies
Community Manager

Re: Need to get the record count

Hi
I want to know why only one record is processed at a time? and how do you get the record count? Can you upload the full screenshot of your job design?

Regards
Shong
----------------------------------------------------------
Talend | Data Agility for Modern Business
Six Stars

Re: Need to get the record count

Hi @sindhurak,

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.


Regards,
Mohit
Highlighted
Five Stars

Re: Need to get the record count

Hi,

 

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.

Five Stars

Re: Need to get the record count

Hi

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 ?

Five Stars

Re: Need to get the record count

Issue has been resolved after i used sequence in the column

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Best Practices for Using Context Variables with Talend – Part 4

Pick up some tips and tricks with Context Variables

Blog

How Media Organizations Achieved Success with Data Integration

Learn how media organizations have achieved success with Data Integration

Read

Definitive Guide to Data Integration

Practical steps to developing your data integration strategy.

Download