0 / 0
tablenode properties

tablenode properties

Table node iconThe 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 Cloud Pak for Data.

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.
Generative AI search and answer
These answers are generated by a large language model in watsonx.ai based on content from the product documentation. Learn more