You are not logged in.
I am updating a excel with multiple sheets.In one of the sheets i have to give summary of all the sheets.
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
Please let me know how it can be achieved?
Thanks in Adavnce.
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.