Hello, I have set of XML files. I want to convert all XML files into a single Excel file. I done this job with tFileList -> tFileInputXML -> tFileOutputExcel. Now I want add an empty row in Excel after reading each XML file. But I don't know how to do with talend. Please help me. Thanks Iyyappan S
use a tFixedFlowInput to generate a empty row and append it to an existing Excel file, for example:
tFileList -iterate> tFileInputXML -main--> tFileOutputExcel_1--oncommponentOK-->tFixedFlowInput--main--tFileOutputExcel_2
tFixedFlowInput, define one column and set its value as ""
tFileOutputExcel_1 and tFileOutputExcel_2, check the 'Append existing file' and 'Append existing sheet' box.
Shong