Dynamic Column Replacer

Allows dynamic updating of a string column containing a string template based on other columns and flow variables.

Replaces any tags in the specified column (using the tag format chosen in the component configuration), with the column or flow variable value.

e.g. $$["myvar"]
would be replaced with the contents of variable myvar.

The format used to mark columns and flow variables within the template is specified from a list of options. If you would like to see additional prefix/suffix options added please contact @takbb on the KNIME forum.


@takbb Brian Bates

Options

Include Type Identifier in dynamically referenced flow-variables

Select this if the flow-variable names include a "type identification" letter (e.g. S for String) before the name

Choose column to dynamically update

Specify the column that contains the template string that is to be replaced

Dynamic Variable format

Choose the string format for inclusion of dynamic variables. KNIME has a variety inconsistent formats across the various nodes used by the different nodes. The aim here is to provide most of the familiar formats.%%00010You can also include the following auto-supplied date/time variables:%%00010Date: dt#yyyy (year) dt#mm (month) dt#dd (day) dt#month (month name) dt#ymd (year-month-day)%%00010Time: tm#hh (hour) tm#mm (minute) tm#ss (second) dt#dts (datetimestamp yyyyMMddhhmmss)

Dynamic Column format

Choose the string format for inclusion of dynamic columns. KNIME has a variety inconsistent formats across the various nodes used by the different nodes. The aim here is to provide most of the familiar formats.%%00010You can also include the following auto-supplied date/time variables:%%00010Date: dt#yyyy (year) dt#mm (month) dt#dd (day) dt#month (month name) dt#ymd (year-month-day)%%00010Time: tm#hh (hour) tm#mm (minute) tm#ss (second) dt#dts (datetimestamp yyyyMMddhhmmss)

Nodes

• Column Rename3 ×
• Row Filter2 ×
• Single Selection Configuration2 ×
• String Manipulation2 ×
• Table Creator2 ×
• Show all 14 nodes

Extensions

• FeatureKNIME Base nodes
• FeatureKNIME Javasnippet
• FeatureKNIME Quick Forms

Links

• No links available