I'm looking for some guidance on the best way to create multiple MS Excel xls or xlsx formatted files, if this is even possible.
The job begins with a tOracleInput, which creates three headers and places the data as needed into an Excel file. However, I need to have multiple xlsx files created, so if there are 5500 rows then six (6) xlsx files are created with no more than 1000 rows per file. This is necessary so the file will meet upload requirements specified by an OEM site, which also does not accept csv files.
Hey, I'm basically in the same boat but I need to instead have different file names for the output. What would I put in the File Name section of the tFileOutputExcel instead to get the same directory but have a different name. Thanks
