Blank Down Strings

Looks at selected string columns in a table and "Blanks down" where the item is repeated across rows. This is designed for output to spreadsheet or similar, for easier reading, so that for example an Invoice number is no longer repeated down each row where it is the same, and is only displayed where it changes between rows.


@takbb Brian Bates 30 Sep 2023

Options

Monitor change of columns to the left

When determining if a value has changed, should it be considered a change if the value of the columns to the left have changed?%%00010Tick to treat as a change based on blanked-down columns to the left of each column

Choose columns to Blank Down

Select the columns that should be blanked when repeated

Nodes

• Column Filter4 ×
• Table Row to Variable4 ×
• Column Rename3 ×
• GroupBy3 ×
• Row Filter3 ×
• Show all 24 nodes

Extensions

• FeatureKNIME Base nodes
• FeatureKNIME Javasnippet
• FeatureKNIME Math Expression (JEP)
• FeatureKNIME Quick Forms

Links

• No links available