i am using talend openstudio 6.3. i want to read the employee,department data from oracle data base and data has to be populated into single excel file with 2 sheets ,one sheet for employee and second sheet for department.
what is the use of "Is absolute Y pos" and append existing file/ append existing sheet option
Replace tFileOutputExcel by differents tHashOutput not linked one to each other.
Then, add as many subjobs as you have Excel files, using tHashinput (refering the good one tHashOutput) as input flow.
Each subjob linked by onSubjobOk, the 1st one linked to the main subjob.
Sorry for the poor details, just on my mobile.
and can the opposite works? I can read from different sheets to the same excel ? I've tried , and it shows like it moving 30 rows but actually the content of the file is empty.
This sounds like it is because you have "activated" the cells but haven't put any data in them. To test this, select the top 100 or so cells from the sheet, right click and select delete. Then re run it.
