Kettle (spoon) - get filename for excel output from field in the excel field in input

Question

I'm trying to process an excel , I need to generate una excel file for each row and as filename I need to use one of the fields in the row.

The excel output hasn't the option "Accept filename from field" and I can't figure out how to achieve it.

thanks

Answer 1

You need to copy the rows into memory and then loop it across the excel file to generate multiple files. You need to break your solution to 2 parts. First of all, read all the rows from Excel Input step into "Copy rows to Result" step as a variable. In the next transformation, use the same variable to use it as a file parameter.

Please check the two links:

• SO Similar Question: Pentaho : How to split single Excel file to multiple excel sheet output
• Blog : https://anotherreeshu.wordpress.com/2014/12/23/using-copy-rows-to-result-in-pentaho-data-integration/

Hope this helps :)