Select if you want to add file names to the Excel output file. Using this option adds file names to the MS Excel output file.

Clear this option if you want to always create the output file, regardless of whether rows are actually written to the file.

If no rows are detected, no file will be created. Select this option if you want this step to create the output file only after the system detects a row for writing to the file. If this option is cleared, the output file is always created, regardless of whether rows are actually written to the file or not. If this option is selected, the step creates the file only after it has detected a row. Wait for first row before creating file (check box)

Replace with new output file: Overwrite the existing output file with the new output file created in this transformation step.

Use existing file for writing: Keep the existing output file and write the new data to it.

If the output file already exists, decide if you want to replace it with the new file or keep the original file. See Common Formats for information on valid date and time formats you can use in this step.Ĭlick to display a list of the files which will be generated. The system date and time will not be appended.įrom the list, select the date and time format you want to include in the file name.

Clear this option to keep the file name as is.

Select this option to append the system date and time to the file name. Select this option to include the date and time in the file name using a format from the Date time format field below. Clear this option to keep the file name as is.Select this option to append the system time to the file name. Select this option to include the system time in the file name, such as in the format ' _235959', for example. Select this option to append the system date to the file name. Select this option to include the system date in the file name, such as in the format ' _20181231', for example. Clear this option to keep the file name as is when multiple copies are launched.Select this option to append a copy number to the file name when multiple copies are launched. Select this option to include the copy number in the file name (' _0', for example) when you run the step in multiple copies, such as launching several copies of a step simultaneously. For example, if you want to split the file every 200 data rows, then enter '200' in this field. The files will be numbered. Specify a positive number to create a new output file every 'n' data rows. This option is only available if you select the '.xlsx ' option in the Extension field above. Clear this check box if you do not want to stream.When you select this check box, the system uses a streaming API to write large files without any memory restrictions (not exceeding MS Excel's limit of 1,048,575 rows and 16,384 columns). Select this option if you want to stream.

Select the Excel file extension to append to the file name. Options include: Specify name and location of the Excel file in which to write the incoming rows from PDI. Variables or parameters can be used in this field.ĭo not include a file extension when the date and time are to be appended and the Extension option is specified. If the data is split over a number of rows, multiple files are created. You can also preview the results from this panel. This panel includes fields for choosing the result file name, extension, and timestamp information.

Microsoft excel template database