I have a transformation with sequential steps of writing data from a table input step to Excel sheets using Excel writer step.
The sheet names are basically provided in the sheet name box in content tab which was reflecting in the spreadsheet.
Instead of per-defining the sheet name, is there any possibility that the sheet names can be dynamically taken from column value of the table.
Ex: say there is a table section and columns section_name , stud_name so i need to show section names as excel sheet name and student names in that section for that particular sheet.
so each sheet represents different section names with student data of that class.
Can anyone help me how to do this in kettle?
Thanks in advance