Icon

2020_​10_​12_​Adding_​Missing_​Records

Adding Missing Records
Adding Missing RecordsThis workflow demonstrates how to use Pivoting/Unpivoting nodes to add missing records into data set.Forum link: https://forum.knime.com/t/add-row-based-on-filters/27537 One Value Column Multiple Value Columns Input data with one value columnPivotingUnpivotingUnpivotingPivotingRemove "+ColumnName"Group to get listSplit listInput data with multiple value columnsPivotingSplit on "+" signTable Creator Pivoting Unpivoting Unpivoting Pivoting String Manipulation GroupBy Split CollectionColumn Table Creator Pivoting Cell Splitter Adding Missing RecordsThis workflow demonstrates how to use Pivoting/Unpivoting nodes to add missing records into data set.Forum link: https://forum.knime.com/t/add-row-based-on-filters/27537 One Value Column Multiple Value Columns Input data with one value columnPivotingUnpivotingUnpivotingPivotingRemove "+ColumnName"Group to get listSplit listInput data with multiple value columnsPivotingSplit on "+" signTable Creator Pivoting Unpivoting Unpivoting Pivoting String Manipulation GroupBy Split CollectionColumn Table Creator Pivoting Cell Splitter

Nodes

Extensions

Links

Download

To use this workflow in KNIME, download it from the below URL and open it in KNIME:

Download Workflow
Created by: Johnny
Created at: 2019-01-03
On NodePit since: 2020-10-12
Last update: 2024-04-27
Created with KNIME version: v4.2.2
Tags: PivotingUnpivotingMissing recordsData Manipulation

Deploy, schedule, execute, and monitor your KNIME workflows locally, in the cloud or on-premises – with our brand new NodePit Runner.

Try NodePit Runner!