Constant Value Column

Adds/replace a column containing a single constant value in each row.

Options

Replace

Select a column which is replaced with the new constant value column.

Append

Add the constant value column as a new column with the given name.

Value settings

In the left combo box you choose the datacell implementation of the column and in the text field the actual column value is entered. You can also choose a flow-variable to provide the value using the button on the right, however the datacell implementation configuration is still necessary.

Note on Double values
Make sure that you use the '.' as the decimal mark in a double value.

Note on Date formats
Note, the date parser uses localization settings so in order to parse foreign language date formats you will need to either convert these formats to the localized representation manually, or change the localization of your system to match that of your data source. A format string as required by the java.text.SimpleDateFormat . Examples:

• "yyyy.MM.dd HH:mm:ss.SSS" parses dates like "2001.07.04 12:08:56.000"
• "yyyy-MM-dd'T'HH:mm:ss.SSSZ" parses dates like "2001-07-04T12:08:56.235-0700"

Valid pattern elements are:

• G: era designator
• y: year
• M: month in year
• w: Week in year
• W: week in month
• D: Day in year
• d: day in month
• F: Day of week in month
• E: day in week
• a: Am/pm marker
• H: hour in day (0-23)
• k: hour in day (1-24)
• K: hour in am/pm (0-11)
• h: hour in am/pm (1-12)
• m: minute in hour
• s: Second in minute
• S: millisecond
• z: Timezone (General time zone)
• Z: RFC 822 time zone

Input Ports

Input table.

Output Ports

Table with added or replaced column holding the defined constant value.

Best Friends (Incoming)

• GroupBy (7 %) 
• Constant Value Column (7 %) Streamable
• Column Rename (6 %) Streamable
• Row Filter (5 %) Streamable
• Concatenate (3 %) Streamable
• Show all 815 recommendations

Best Friends (Outgoing)

• Concatenate (16 %) Streamable
• Joiner (8 %) 
• Constant Value Column (7 %) Streamable
• Column Rename (5 %) Streamable
• GroupBy (5 %) 
• Show all 759 recommendations

Workflows

• _​01_​PMR_​Analysis (KNIME Hub) 
• 00_​Guided_​Labeling_​for_​Document_​Classification_​(legacy) (KNIME Hub) 
• 00_​Python Test (KNIME Hub) 
• 008_​Loops - 1 (KNIME Hub) 
• 01_​Accessing_​Transforming_​and_​Modeling_​Time_​Series (KNIME Hub) 
• Show all 799 workflows

Installation

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

A zipped version of the software site can be downloaded here.

You don't know what to do with this link? Read our NodePit Product and Node Installation Guide that explains you in detail how to install nodes to your KNIME Analytics Platform.

Developers

You want to see the source code for this node? Click the following button and we’ll use our super-powers to find it for you.