Fix Table After Column Append

Fixes tables that have been generated with repeated (#Iter ) columns following Loop End Column Append

This reduces the columns to the required original set and concatenates the repeating columns below thereby extending the rows and reduce the repeating columns.

Component by @takbb
Building on idea from @badger101

28 September 2022

Options

Regex String to identify "repeated" columns

Enter a pattern that identifies the column names that mark a column as "a repeat" %%00010e.g.%%00010.*#Iter.* will treat any column name containing (#Iter ) as a repeating column

Nodes

• Transpose3 ×
• Column Filter2 ×
• Extract Column Header2 ×
• Component Input1 ×
• Component Output1 ×
• Extract Table Dimension1 ×
• Group Loop Start1 ×
• Insert Column Header1 ×
• Loop End1 ×
• Math Formula1 ×
• String Configuration1 ×

Extensions

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

Links

• No links available