You are not logged in.
Announcement
Unanswered posts
|
Pages: 1
- Index
- » Talend Open Studio for Data Integration » Usage, Operation
- » count no of lines in excel sheet
#1 2012-04-12 12:24:32
- animesh
- Member
- Registered: 2012-02-02
- Posts: 13
count no of lines in excel sheet
Hi,
I am updating a excel with multiple sheets.In one of the sheets i have to give summary of all the sheets.
e.g.
sheet1,sheet2,sheet3,summary
the summary sheet will contains no of records updated in the 3 sheets.
say, if 5 records went into sheet1 , 6 in sheet 2 and 7 in sheet3.
so the summary sheet will be like this
column A column B
sheet1 5
sheet2 6
sheet3 7
Please let me know how it can be achieved?
Thanks in Adavnce.
Offline
#2 2012-04-13 01:13:11
Re: count no of lines in excel sheet
Hi animesh,
In Talend, each component has a set of variables attached to it, you can find that list in the "Outline" view on the bottom left of your screen. For the ExcelOutput component, you should have a "NbRowsInserted" variable, or something like that.
You could make the different updates, and then OnSubjobOK retrieve the number of Rows Inserted or Updated in the different components by using these variables.
Vincent Galopin
US Pre-Sales Consultant
Talend US
Offline
Pages: 1
- Index
- » Talend Open Studio for Data Integration » Usage, Operation
- » count no of lines in excel sheet