How to dynamically create excel sheets in Talend community(Free version)?
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.
One potential solution is to use the 'Split output in several files' 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:
