tablenode properties | IBM Cloud Pak for Data as a Service

tablenode properties

Last updated: Nov 22, 2024

tablenode properties

Table node icon The Table node displays data in table format. This is useful whenever you need to inspect your data values.

Note: Most of the properties on this page are only supported in SPSS Modeler Desktop streams, not in SPSS Modeler in watsonx.ai Studio.

Example

stream = modeler.script.stream()
typenode = stream.findByID("id42KW3MSA94B")

node = stream.create("table", "My node")
stream.link(typenode, node)
node.setPropertyValue("highlight_expr", "Age > 30")

node.run([])

Table 1. tablenode properties
`tablenode` properties	Data type	Property description
`full_filename`	string	If disk, data, or HTML output, the name of the output file.
`use_output_name`	flag	Specifies whether a custom output name is used.
`output_name`	string	If `use_output_name` is true, specifies the name to use.
`output_mode`	`Screen` `File`	Used to specify target location for output generated from the output node.
`output_format`	`Formatted` (.tab) `Delimited` (.csv) `HTML` (.html) `Output` (.cou)	Used to specify the type of output.
`transpose_data`	flag	Transposes the data before export so that rows represent fields and columns represent records.
`paginate_output`	flag	When the `output_format` is `HTML`, causes the output to be separated into pages.
`lines_per_page`	number	When used with `paginate_output`, specifies the lines per page of output.
`highlight_expr`	string
`output`	string	A read-only property that holds a reference to the last table built by the node.
`value_labels`	[[Value LabelString] [Value LabelString] ...]	Used to specify labels for value pairs.
`display_places`	integer	Sets the number of decimal places for the field when displayed (applies only to fields with REAL storage). A value of `–1` will use the flow default.
`export_places`	integer	Sets the number of decimal places for the field when exported (applies only to fields with REAL storage). A value of `–1` will use the stream default.
`decimal_separator`	`DEFAULT` `PERIOD` `COMMA`	Sets the decimal separator for the field (applies only to fields with REAL storage).
`date_format`	`"DDMMYY" "MMDDYY" "YYMMDD" "YYYYMMDD" "YYYYDDD" DAY MONTH "DD-MM-YY" "DD-MM-YYYY" "MM-DD-YY" "MM-DD-YYYY" "DD-MON-YY" "DD-MON-YYYY" "YYYY-MM-DD" "DD.MM.YY" "DD.MM.YYYY" "MM.DD.YYYY" "DD.MON.YY" "DD.MON.YYYY" "DD/MM/YY" "DD/MM/YYYY" "MM/DD/YY" "MM/DD/YYYY" "DD/MON/YY" "DD/MON/YYYY" MON YYYY q Q YYYY ww WK YYYY`	Sets the date format for the field (applies only to fields with `DATE` or `TIMESTAMP` storage).
`time_format`	`"HHMMSS"` `"HHMM"` `"MMSS"` `"HH:MM:SS"` `"HH:MM"` `"MM:SS"` `"(H)H:(M)M:(S)S"` `"(H)H:(M)M"` `"(M)M:(S)S"` `"HH.MM.SS"` `"HH.MM"` `"MM.SS"` `"(H)H.(M)M.(S)S"` `"(H)H.(M)M"` `"(M)M.(S)S"`	Sets the time format for the field (applies only to fields with `TIME` or `TIMESTAMP` storage).
`column_width`	integer	Sets the column width for the field. A value of `–1` will set column width to `Auto`.
`justify`	`AUTO` `CENTER` `LEFT` `RIGHT`	Sets the column justification for the field.