Column sorting after pivoting

Hi, i’m new to Knime.
I did a pivoting and the column is aggregated by Month+Vol and Month+NS.
2022-01 vol, 2022-01 NS, 2022-02 vol, 2022-02 NS, 2022-03 vol, 2022-04 NS

I’d like to sort it as
2022-01 vol, 2022-02 vol, 2023 vol, 2022-01 NS, 2022-02 NS, 2022-03 NS

any idea? Thanks.

1 Like

Hello @CCCCH and welcome to the KNIME forum.

You can proceed in manual way with Column Resorter node. Or more in a more authomatized way, by feeding it with column headers sorting in Reference Column Resorter node.



This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.