Edit Nominal Domain

KNIME Base Nodes version 3.7.1.v201901291053 by KNIME AG, Zurich, Switzerland

Options

Select column

Selects the column for which the domain values should be edited. Non-string typed columns are filtered out. A column name with red border indicates that the domain values for this columns were previously configured but the column either no longer exists or has a different type (no string column anymore). Red written domain value orderings can be edited as others and in addition deleted. (See the Reset/Delete option)

Add

Creates a new cell with the given value and inserts it at the selected position. Self created cells are green marked in the possible value list.

Remove

Removes all selected self created cells (green marked) or cells which are not contained in the possible value set of the original column specification (red marked). It is not possible to remove other possible values, i.e. the possible values defined by the original column specification, as that might corrupt the table consistency.

Sort alphabetical [A-Z, Z-A]

Sorts the elements in alphabetical order ascending (A-Z) or descending (Z-A).

Move one step [Up, Down]

Moves the selected element(s) one up or down. If the top or the bottom of the list is reached, the selected element(s) is/are enqueued on the other end of the table again.

Move first/last

Moves the selected element(s) to the top or at the end of the table.

Reset/Delete

Restores the original domain value list as in the input table. If a not existing but previously configured column is selected (written in red), this button is labeled with 'Delete' and deletes the stored configuration for the selected column.

If a configured columns is not present in data

Determines if the execution should either fail or the column should be ignored if a configured column does not exist in the input table.

If a configured columns has an incompatible type

Determines if the execution should either fail or the column should be ignored if the types of a configured column are not equal.

Input Ports

Input data

Output Ports

Input data with changed specification.

Best Friends (Incoming)

• Domain Calculator (14 %) Manipulator
• CSV Reader (7 %) Source
• File Reader (7 %) SourceStreamable
• Number To String (7 %) Manipulator
• Column Filter (7 %) ManipulatorStreamable
• GroupBy (7 %) Manipulator
• String Manipulation (7 %) ManipulatorStreamable
• Excel Reader (XLS) (7 %) SourceStreamable
• Column Rename (5 %) ManipulatorStreamable
• Number Formatter (2 %) Manipulator
• Table Creator (2 %) Source
• Naive Bayes Learner (2 %) LearnerDeprecated
• Logistic Regression Learner (2 %) LearnerDeprecated
• Concatenate (2 %) ManipulatorStreamable
• Edit Nominal Domain (Dictionary) (2 %) Manipulator
• Edit Numeric Domain (2 %) Manipulator
• Row Filter (2 %) ManipulatorStreamable
• Reference Row Filter (2 %) Manipulator
• Joiner (2 %) Manipulator
• Missing Value (2 %) Manipulator
• Sorter (2 %) Manipulator
• Rule-based Row Filter (2 %) ManipulatorStreamable
• Create Collection Column (< 1 %) ManipulatorStreamable
• Database Reader (< 1 %) Source
• List Files (< 1 %) Source
• Loop End (< 1 %) LoopEnd
• k-Means (< 1 %) LearnerDeprecated
• K Nearest Neighbor (< 1 %) LearnerStreamableDeprecated
• Random Forest Learner (< 1 %) LearnerDeprecated
• Category To Number (< 1 %) ManipulatorStreamable
• Row Splitter (< 1 %) ManipulatorStreamable
• String To Number (PMML) (< 1 %) Manipulator
• Rank (< 1 %) Manipulator
• String Replace (Dictionary) (< 1 %) ManipulatorStreamable
• Rule Engine (< 1 %) PredictorStreamable
• Lift Chart (< 1 %) Visualizer
• Color Manager (< 1 %) Visualizer
• XLS Reader (< 1 %) SourceDeprecated
• String Matcher (< 1 %) Learner
• String to Date/Time (legacy) (< 1 %) ManipulatorStreamable
• Show all 40 recommendations

Best Friends (Outgoing)

• Nominal Value Row Filter (18 %) ManipulatorStreamable
• Group Loop Start (8 %) LoopStart
• One to Many (8 %) Manipulator
• R Plot (5 %) Visualizer
• GroupBy (5 %) Manipulator
• Partitioning (5 %) Manipulator
• Color Manager (5 %) Visualizer
• Decision Tree Learner (3 %) Learner
• Logistic Regression Learner (3 %) LearnerDeprecated
• Create Bit Vector (3 %) Manipulator
• Linear Correlation (3 %) Other
• Domain Calculator (3 %) Manipulator
• Edit Nominal Domain (Dictionary) (3 %) Manipulator
• Nominal Value Row Splitter (3 %) ManipulatorStreamable
• Row Filter (3 %) ManipulatorStreamable
• Joiner (3 %) Manipulator
• String Replacer (3 %) ManipulatorStreamable
• Rule-based Row Filter (3 %) ManipulatorStreamable
• Extract Table Dimension (3 %) Other
• Conditional Box Plot (3 %) Visualizer
• Histogram (interactive) (3 %) Visualizer
• WrappedNode Output (3 %) 
• Math Formula (3 %) ManipulatorStreamable
• Python View (3 %) VisualizerDeprecated
• String to Date/Time (legacy) (3 %) ManipulatorStreamable
• Table Writer (< 1 %) Sink
• RProp MLP Learner (< 1 %) Learner
• Logistic Regression Learner (< 1 %) Learner
• Regression Predictor (< 1 %) PredictorDeprecated
• Random Forest Learner (Regression) (< 1 %) LearnerDeprecated
• Category To Number (< 1 %) ManipulatorStreamable
• Table Validator (< 1 %) Manipulator
• Table Validator (Reference) (< 1 %) Manipulator
• Column Filter (< 1 %) ManipulatorStreamable
• Row Splitter (< 1 %) ManipulatorStreamable
• Pivoting (< 1 %) Manipulator
• Column Rename (< 1 %) ManipulatorStreamable
• Row Sampling (< 1 %) Manipulator
• String Manipulation (< 1 %) ManipulatorStreamable
• Target Shuffling (< 1 %) Manipulator
• Rule Engine (< 1 %) PredictorStreamable
• CASE Switch Data (Start) (< 1 %) Manipulator
• JavaScript Conditional Box Plot (< 1 %) 
• DL4J Feedforward Learner (Classification) (< 1 %) Learner
• LatitudeLongitudeToCoordinate (< 1 %) Manipulator
• Show all 45 recommendations

Installation

To use this node in KNIME, install KNIME Base Nodes from the following update site: