https://community.qlik.com/t5/Talend-Studio/How-to-dynamically-create-excel-sheets-in-Talend-community-Free/m-p/2540048#M148295 <P>Hello&nbsp;</P> <P>One potential solution is to use the '<STRONG>Split output in several files</STRONG>' option on the tFileOutputDelimited component to split the data into multiple text files. Afterward, iterate through each text file and append all the data into a single Excel file with a dynamic sheet. The Job would resemble the following:</P> <P>tMysqlInput--main--tFileOutputDelimiited</P> <P>|onsubjobok</P> <P>tFileList--iterate--tFileInputDelimted--main--tFileOutputExcel</P> <P>&nbsp;</P> <P>Regards</P> <P>Shicong</P> Wed, 31 Dec 2025 05:23:48 GMT Shicong_Hong 2025-12-31T05:23:48Z https://community.qlik.com/t5/Talend-Studio/How-to-dynamically-create-excel-sheets-in-Talend-community-Free/m-p/2525072#M147811 <P>Hi, I want to dynamically create excel sheets in Talend free version after every 10 million records. Is there any method to do it? Can someone provide a solution with a flowchart.</P> <P><LI-PRODUCT title="Talend Studio" id="qlik_TalendStudio"></LI-PRODUCT>&nbsp;</P> Wed, 23 Jul 2025 12:00:34 GMT https://community.qlik.com/t5/Talend-Studio/How-to-dynamically-create-excel-sheets-in-Talend-community-Free/m-p/2525072#M147811 Aryan123 2025-07-23T12:00:34Z https://community.qlik.com/t5/Talend-Studio/How-to-dynamically-create-excel-sheets-in-Talend-community-Free/m-p/2540048#M148295 <P>Hello&nbsp;</P> <P>One potential solution is to use the '<STRONG>Split output in several files</STRONG>' option on the tFileOutputDelimited component to split the data into multiple text files. Afterward, iterate through each text file and append all the data into a single Excel file with a dynamic sheet. The Job would resemble the following:</P> <P>tMysqlInput--main--tFileOutputDelimiited</P> <P>|onsubjobok</P> <P>tFileList--iterate--tFileInputDelimted--main--tFileOutputExcel</P> <P>&nbsp;</P> <P>Regards</P> <P>Shicong</P> Wed, 31 Dec 2025 05:23:48 GMT https://community.qlik.com/t5/Talend-Studio/How-to-dynamically-create-excel-sheets-in-Talend-community-Free/m-p/2540048#M148295 Shicong_Hong 2025-12-31T05:23:48Z