|
|
The Table node displays the data in table format, which can also be written to a file. This
is useful anytime that you need to inspect your data values or export them in an easily readable
form.
|
Example
node = stream.create("table", "My node")
node.setPropertyValue("highlight_expr", "Age > 30")
node.setPropertyValue("output_format", "HTML")
node.setPropertyValue("transpose_data", True)
node.setPropertyValue("full_filename", "C:/output/table_output.htm")
node.setPropertyValue("paginate_output", True)
node.setPropertyValue("lines_per_page", 50)
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 stream 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. |
