In the node_response.json file, there are a number of options that can be selected for the new columns for specialized display in the result. The array Options
holds these optional parameters as key-value pairs that are recognized when creating the new columns. There are different key values available:
PositionAfter
—The new column will be placed after the specified column.PositionBefore
—The new column will be placed before the specified column.RelativePosition
—An integer value specifying the relative position of the column.PlotType
- specifies the plot type where the new column can be plotted in a chart
- Valid values areNumeric
,Categorical
, andOrdinal
. If there are multiple plot types, separate by comma (for example,Numeric, Categorical
).
- If no plot type is defined:
• Boolean columns are automatically classified asCategorical
• Numeric columns are classified asNumeric, Ordinal
.
• All others are specified asNone
.FormatString
- specified how numerical values are formatted and displayed. By default, float values have a format string of F5, which means they are displayed to 5 significant figures.SpecialCellRenderer
—The data within a column can be shown with an alternative presentation rather than as a raw data value. Here are the possible options:
-exclamationMark
—90550C2D-EB8D-443E-9F23-9E735FB23F9A - displays a string column. It shows an error icon if the value is not empty. The tool tip for the image is the full text.
-boolCheckMark
—330D9522-50CC-41B7-9D45-5E5D8F708103 - displays a Boolean value. It shows a green check mark if the value is true.
-boolCrossMark
—4B8956F1-3A54-423D-8654-60676825230F - displays a Boolean value. It shows a check mark (X) if the value is true.
-boolYesNo
—9085D14E-388D-4EF0-91C1-B4B2BDF33AD3 - displays a Boolean value with the words "Yes" and "No".
-fileName
—EB29D794-4F2E-4785-8B80-A24D8C0FB3E4 - for string column. Displays a filename (a string) by only showing the filename in the table field and showing the full path in the tooltip.
-fileSize
—FBBFBB0B-A2D0-468F-95BF-25BCD0A42FE9 - displays an integer as a file size.
-percentBar
—64516B23-565C-4036-87DA-29189E9E62A3 - displays a number between 0 and 100 as a column between 0% and 100%.
-monospaced
—59E4C754-AD43-42FD-B4D9-C8CF0F622BD3 - displays any number or text using a monospaced font rather than a proportional font.
-concatenatedMultiline
—410B767F-0C21-4E97-BB3D-041186955807 - displays a text that consists of multiple lines as one line that features the multiple lines concatenated using a ; (semicolon).