[resolved] Iterate rows into multiple Excel sheets
Hi, I would like to create a job like this: 1. using tMSSqlInput to read list of employees in 1 table, resulting in: 1, Henry 2, Other employee 2. From the ID retrieved, I would like to get the list of projects: 1, Project A 2, Project B 3. Dump the info to an Excel file into multiple sheet (sheet name based on the employee ID). Can I achieve this using Talend?