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.
Hey @jms2510 to add to @gawa point if you don't have it already you should create a field with the Full File Path if its not already there
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?
