Once I add the dynamic input tool to read the sheet names, how do I output an Excel file for each one?
hi @jms2510
In general, we utilize "Take File/Table Name from Field" option of Output tool to dynamically change file path.
The field "Sheet Names" is what I put into the dynamic input tool, but it is not showing up in the "Take File/Table Name from Field" option of the Output tool. (F4 is a column within the workbook)
Hi @gawa
The field "Sheet Names" is what I put into the dynamic input tool, but it is not showing up in the "Take File/Table Name from Field" option of the Output tool. (F4 is a column within the workbook)
Why not just read the Excel workbook in using the directory tool? and then bring in the sheet names separately and join them up before outputting?