Domain Calculator

Scans the data and updates the possible values list and/or the min- and max values of selected columns. This node is useful when the domain information of the data has changed and must be updated in the table specification, for instance, the domain information as contained in a table spec may be void when a row filtering (e.g. outlier removal) is carried out.

Options

Columns

Include the columns, for which possible values shall be determined and be put in the table specification. The default dialog option selects all columns, which can represent themselves as String. For all non-selected columns (the Exclude list) the possible value domain will be dropped or retained, depending on the selection of the corresponding buttons below the Exclude list.

Excluded columns

Choose what to do with the possible value domain for columns in the exclude list. You can either retain the existing domain information from the input table or drop it completely.

Maximum number of possible values

Restrict the number of different values that will be determined for each column. If a column has more possible values than this limit, all values will be discarded and the column's metadata won't support querying possible values. Leave unchecked for unlimited values.

Columns

Select all columns for which min and max values shall be determined. The default dialog option includes all "boundable" columns, for instance numeric ones.

Excluded columns

Choose what to do with the min/max domain information for columns in the exclude list. You can either retain the existing min/max domain from the input table or drop it completely.

Views

This node has no views

Workflows

• _01_Network_Traffic_ReportingKNIME Hub
• !Modern UI_ABC-XYX-RFM AutoML SuperstoreKNIME Hub
• 00 Data GenerationKNIME Hub
• 00 Data GenerationKNIME Hub
• 00_DataApp_Visual_Analysis_of_Sales_DataKNIME Hub
• Show all 1107 workflows

Links

• Legacy Range from Filtered Columnby HansS on 2020-02-28

  forum.knime.com/p/82962
• Unused string values after joinerby AnotherFraudUser on 2020-05-25

  forum.knime.com/p/92311
• How to calculate nominal domain for more than 60 unique valuesby izaychik63 on 2020-04-25

  forum.knime.com/p/88935
• Table Difference Checker node failing execution despite equal input tablesby qqilihq on 2018-08-30

  forum.knime.com/p/47139
• How to randomly pick a string from existing table?by kowisoft on 2019-07-03

  forum.knime.com/p/64339
• Show all 19 links

Developers