Additional output fields tab

Pentaho Data Integration

Version
9.3.x
Audience
anonymous
Part Number
MK-95PDIA003-15
Microsoft Excel Input step Additional output fields tab

The Additional output fields tab contains the following options to specify additional information about the file to process:

Option Description
Full filename field Specify the field that contains the full file name plus the extension.
Sheetname field Specify the field that contains the name of worksheet you want to use.
Sheet row nr field Specify the field that contains the current sheet row number you want to use.
Row nr written field Specify the field that contains the number of rows written.
Short filename field Specify the field that contains the filename without path information but with an extension.
Extension field Specify the field that contains the extension of the filename.
Path field Specify the field that contains the path in operating system format.
Size field Specify the field that contains the size of the data.
Is hidden field Specify the field indicating if the file is hidden or not (Boolean).
Uri field Specify the field that contains the URI.
Root uri field Specify the field that contains only the root part of the URI.