Icon

kn_​forum_​38571_​pivot

example for Pivot table

example for Pivot table
also ... if you later want to change the order of your columns after a "header" (like in a Pivot table) and do not want to use the lexcial sort in the Pivot node ....
https://forum.knime.com/t/question-to-get-an-output/38571/9?u=mlauber71

example for Pivot tablealso ... if you later want to change the order of your columns after a "header" (like in a Pivot table) and do not want to use the lexcial sort in the Pivot node ....https://forum.knime.com/t/question-to-get-an-output/38571/9?u=mlauber71 if you later want to change the order of your columns after a "header" (like in a Pivot table) and do not want to use the lexcial sort in the Pivot node .... input.txttest_data.tabletest_data.tableyyyy/MM/ddNode 5MONTHMONTH_YEAR^(?!Year$|Month \(number\)).*Eligiblecount Y as 1$Eligible for regulatory review$ = "Y" => 1$Eligible for regulatory review$ = "N" => 0^(?!Year$|Month \(number\)).*sort column namessort the data columnsby stringColumn Header asRowIDkeep the pivotheaders on top$Column Header$ = "MONTH_YEAR" => TRUETRUE => FALSEColumn Header asRowIDcolumn sorted that are not headersnew column position File Reader Table Writer Table Reader String to Date&Time Extract Date&TimeFields String Manipulation String Manipulation Pivoting Missing Value Sorter Column Filter Rule Engine Missing Value Sorter Column Filter Pivoting ExtractColumn Header Transpose Sorter RowID Rule-basedRow Splitter RowID Concatenate ReferenceColumn Resorter Java Snippet(simple) example for Pivot tablealso ... if you later want to change the order of your columns after a "header" (like in a Pivot table) and do not want to use the lexcial sort in the Pivot node ....https://forum.knime.com/t/question-to-get-an-output/38571/9?u=mlauber71 if you later want to change the order of your columns after a "header" (like in a Pivot table) and do not want to use the lexcial sort in the Pivot node .... input.txttest_data.tabletest_data.tableyyyy/MM/ddNode 5MONTHMONTH_YEAR^(?!Year$|Month \(number\)).*Eligiblecount Y as 1$Eligible for regulatory review$ = "Y" => 1$Eligible for regulatory review$ = "N" => 0^(?!Year$|Month \(number\)).*sort column namessort the data columnsby stringColumn Header asRowIDkeep the pivotheaders on top$Column Header$ = "MONTH_YEAR" => TRUETRUE => FALSEColumn Header asRowIDcolumn sorted that are not headersnew column positionFile Reader Table Writer Table Reader String to Date&Time Extract Date&TimeFields String Manipulation String Manipulation Pivoting Missing Value Sorter Column Filter Rule Engine Missing Value Sorter Column Filter Pivoting ExtractColumn Header Transpose Sorter RowID Rule-basedRow Splitter RowID Concatenate ReferenceColumn Resorter Java Snippet(simple)

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: m_lauber
Created at: 2022-01-04
On NodePit since: 2022-01-05
Last update: 2024-04-28
Created with KNIME version: v4.5.0
Tags: pivottablecolumnsortresort

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

Try NodePit Runner!