Icon

2021_​06_​28_​ColumnCrossCheck

Title

Desc

Complete datacomparison Summary ofRepeated: Summary ofRepeatedUnpivoted: Node 40Column with ColumnHeadersNode 45methodUnique CountID column nameapplyunique countcurrentAttribute column in loopYOUR DATAfrom JOIN nameback to attribute namenew_column_nameold_column_nameCollectionsum 4filter > 4ID outJOINrenamejoin_column_nameback to unique ID23 rowsJOINrenameunique count new namereset Row IDID (unique)columnappendID (unique)repeateditems by columnand rowMD5encrypting recommended to work with 'many' attributes.Removing outter comand and bracketswill mantain the 'pasted attributes' format Unique PASTED attributesSummary of repeatedUnpivotAttributesUnpivotCountsJOINERJOINERUnpivotedAttributes+ CountsReportingColumn HeadersSelectColumnsSortReported ColumnsUnpivoted Report'Repeated' ExtractColumn Header Unpivoting Table Row ToVariable Loop Start Java EditVariable (simple) Java EditVariable (simple) GroupBy Column Filter Table Creator Column Rename Java EditVariable (simple) Java EditVariable (simple) Loop End (ColumnAppend) Math Formula Rule-basedRow Filter Column Filter Column Rename Java EditVariable (simple) Joiner Column Rename Column Rename RowID Column Filter Column Appender Column Filter String Manipulation GroupBy Joiner Unpivoting Unpivoting String Manipulation String Manipulation Joiner Column Rename Column Filter Column Resorter Row Filter Complete datacomparison Summary ofRepeated: Summary ofRepeatedUnpivoted: Node 40Column with ColumnHeadersNode 45methodUnique CountID column nameapplyunique countcurrentAttribute column in loopYOUR DATAfrom JOIN nameback to attribute namenew_column_nameold_column_nameCollectionsum 4filter > 4ID outJOINrenamejoin_column_nameback to unique ID23 rowsJOINrenameunique count new namereset Row IDID (unique)columnappendID (unique)repeateditems by columnand rowMD5encrypting recommended to work with 'many' attributes.Removing outter comand and bracketswill mantain the 'pasted attributes' format Unique PASTED attributesSummary of repeatedUnpivotAttributesUnpivotCountsJOINERJOINERUnpivotedAttributes+ CountsReportingColumn HeadersSelectColumnsSortReported ColumnsUnpivoted Report'Repeated' ExtractColumn Header Unpivoting Table Row ToVariable Loop Start Java EditVariable (simple) Java EditVariable (simple) GroupBy Column Filter Table Creator Column Rename Java EditVariable (simple) Java EditVariable (simple) Loop End (ColumnAppend) Math Formula Rule-basedRow Filter Column Filter Column Rename Java EditVariable (simple) Joiner Column Rename Column Rename RowID Column Filter Column Appender Column Filter String Manipulation GroupBy Joiner Unpivoting Unpivoting String Manipulation String Manipulation Joiner Column Rename Column Filter Column Resorter Row Filter

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: 2022-02-06
Last update: 2024-12-24
Created with KNIME version: v4.3.1

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

Try NodePit Runner!