Icon

Multiheader Transpose Challenge 2

Multiheader Transpose Challenge 1

There has been no description set for this workflow's metadata.

optional - convert value to numeric fill downsample data with " ? "in place of missing valuesconvert the " ? " to "missing"determine mapping levelthis is key tofinding the correct columnsinto which the description"account" should be subsequently placedremove the "header"rows wherevalue is missingtidy upretainoriginal rowidwe need to usethis as a value for grouping in the pivotgenerate "Map n" column namesinto "mapLevel"columnput itemsinto correctcolumns accordingto "mapping level"strip spacesfrom valuesconvert valueto numerictidy up Missing Value Table Creator Rule Engine Java Snippet Row Filter Column Filter RowID String Manipulation Pivoting Column Resorter String Manipulation String To Number RowID optional - convert value to numeric fill downsample data with " ? "in place of missing valuesconvert the " ? " to "missing"determine mapping levelthis is key tofinding the correct columnsinto which the description"account" should be subsequently placedremove the "header"rows wherevalue is missingtidy upretainoriginal rowidwe need to usethis as a value for grouping in the pivotgenerate "Map n" column namesinto "mapLevel"columnput itemsinto correctcolumns accordingto "mapping level"strip spacesfrom valuesconvert valueto numerictidy upMissing Value Table Creator Rule Engine Java Snippet Row Filter Column Filter RowID String Manipulation Pivoting Column Resorter String Manipulation String To Number RowID

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: aqudi
Created at: 2023-09-03
On NodePit since: 2023-09-04
Last update: 2024-04-27
Created with KNIME version: v4.7.7

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

Try NodePit Runner!